|
|
-
|
|
I have drafted all the new features and enhancements introduced by SQL Server denali CTP1 and CTP3. Multi Monitor Support is the new feature among them.
We can do with this feature:
1. Using this feature we can use multi screen of query analyzer or editor.
2. You can monitor separately it an......
|
|
-
|
|
Recently while working with SQL CLR functionality and created DLL for the SQL CLR.
But while registering this DLL in the database i got one surprised error.
Lt's show you the script so you have more idea. We have a script to register DLL as following,
SP_CONFIGURE 'clr enabled',1
GO
RECON......
|
|
-
|
|
As a best practice, DBA need to verify each database backups are properly done or not, also make sure the backups are OK then is readable and can be restored. Because so many databases are scheduled as FULL and differential backups weekly/daily and transaction log backups on every hours or whatev......
|
|
-
|
|
After posting some snaps to configure transactional replication in sql server having publication server as distributor, i want to share some of the issue which i got during working with it.
You may also faced the same issue and got resolved as well. You can comment if you faced any other replic......
|
|
-
|
|
0)
DROP TABLE GroupingTable
CREATE TABLE GroupingTable
(
MainCategoryName VARCHAR(100)
,SubCategoryId VARCHAR(100)
,VALUE BIG......
|
|
-
|
|
Registered Servers
or
press Ctrl + Alt + G......
|
|
-
|
|
Problem:
Before a few days ago i have installed SQL Server Denali CTP3. Then i have querying in query analyzer and found, minimizing result is not working with CTRL+R is not working. Before CTP3 i have already Denali CTP1 installed in my machine and it was working perfectly, So it stopping to w......
|
|
-
|
|
As i have started to learn new functions arrived by SQL Server Denali CTP3 version and i have posted some of them. You can learn Analytical functions, Conversion functions and String functions. You can also get the list of all the features coming in SQL Server 2011 CTP3.
Now diverting on this......
|
|
-
|
|
<div dir="ltr" style="text-align: left;" trbidi="on">
During development of stored procedures, i ran into one issue and this was due to not applied best practice of stored procedures practice and this issue comes mostly when we call stored procedures inside another one and so on, which are used in ......
|
|
-
|
|
I hope you may read my earlier posts for Analytical functions and Conversion functions which are introduced in SQL Server 2011 CTP3. You can also move on What's New of Denali CTP3 here. Here i am going to explain new string functions which are also arrived in this SQL Server 11 CTP3 version also. <......
|
|