|
|
-
13
Liked
| 12
Learned
| 11
Comments
|
|
Adding the /NOSPLASH option to your Visual Studio\BIDS shortcut will make Visual Studio\BIDS launch quicker :
%ProgramFiles%\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe /NOSPLASH
%ProgramFiles(x86)%\Microsoft Visual Studio 10.0\Common7\IDE\d......
|
|
-
|
|
My team mate was working with legacy code. Code used ISNULL and NULLIF functions, he got confused becauase of similar name.
Thought of sharing with you all.
ISNULL - Replaces NULL with the specified replacement value.
NULLIF - Returns a null ......
|
|
-
13
Liked
| 15
Learned
| 7
Comments
|
|
Is it unbeleivable? See the below example
[code]Create procedure GO
as
select 1 as number[/code]
Now execute it without using keywords EXEC or EXECUTE
[code]GO[/code]GO is treated as batch seperator and you wont get any result. Now execute it by[......
|
|
-
13
Liked
| 10
Learned
| 3
Comments
|
|
Today I learned an tip from my colleague about finding the last executed statement for a process in SQL Server.
[code]
DBCC INPUTBUFFER (52)
[/code]
Here 52 is the SPID, that we want to check last executed statement......
|
|
-
13
Liked
| 13
Learned
| 1
Comments
|
|
We might have used below commands while working on Tuning to identify the CPU time, Elapse Time and ,No.of Reads.
SET STATISTICS IO ON
SET STATISTICS TIME ON
We can combine this two commands on a single line by separating them with commas as bel......
|
|
-
|
|
'EXCEPT' will show any distinct value from first query result that is not found in second query result.
Select item_id from itemmaster
except
Select item_id from stock
'INTERSECT' will show any distinct values, which are common in both first & ......
|
|
-
13
Liked
| 14
Learned
| 0
Comments
|
|
Recently learned from Ana's blog here that, in Denali, now execution plan will show some warnings also. While executing query, if it finds any bottlenecks, it will show the warnings in the execution plan against that iterator.
When you see the actual......
|
|
-
|
|
While trying to delete the database, you might have encountered this error:
'Cannot drop database because it is currently in use'
This may happen if the connection was opened.
Solution:
Right click the database->Delete->Check the checkbox cl......
|
|
-
|
|
Recently we had a very puzzling situation. The stored procedure worked fine from the two desktop applications, but failed when called from the middle tier dll in the web environment. My colleague spent quite an amount of time debugging this problem and ......
|
|
-
13
Liked
| 11
Learned
| 5
Comments
|
|
Just Learned from Tony Rogerson's blog "How to make a table Read Only in SQL Server". It would be making the file group read only because another benefit of that is that SQL Server doesn’t have to issue locks.
[code]
USE [master]
GO
ALTER DATABASE......
|
|