|
|
-
18
Liked
| 21
Learned
| 5
Comments
|
|
Careful! If you are using your old scripts to create database in SQL 2012, It might fail. In SQL Server 2012, Minimum database size is increased to 3MB. In before versions it is 2MB. So, if you run the same script with initial size specified as 2MB, it ......
|
|
-
18
Liked
| 18
Learned
| 4
Comments
|
|
Just learned from Pinal's blog that you can open a web page within SQL Server Management Studio. You can even split the main window where on one side you can type your TSQL code and on the other half you can view web pages. This can be extremely helpful......
|
|
-
20
Liked
| 18
Learned
| 7
Comments
|
|
DBA should keep a list of tables which are not being used / referenced by anyone in last few weeks. At times, we come up with a requirement where developer asks, can I have list of unused tables or “Can you tell me the tables which are not being used i......
|
|
-
16
Liked
| 18
Learned
| 3
Comments
|
|
Recently I got a requirement to display groups along with number of products in the group, where cost of product falls in certain range. Additional requirement is, even if a group doesn’t have any items in the range; still show that group with the Numb......
|
|
-
18
Liked
| 18
Learned
| 7
Comments
|
|
I just learned that while working in SSMS if you have a doubt you can ask in msdn forum using
the toolbar "Community > Ask a question" and the forum web page opens right within Books Online.......
|
|
-
16
Liked
| 17
Learned
| 10
Comments
|
|
One of the problems I always faced when storing multi-line text into a SQL Server table is the trouble in retrieving it and analysing it in SSMS. If I take output to Grid, I will lose the line breaks and formatting. If I take output to text, it is trunc......
|
|
-
16
Liked
| 17
Learned
| 8
Comments
|
|
Often in forums, we will see this question, "How to calculate running total?". There are various complex methods available for this and this is one of often discussed topic. Now In SQL Server 2012, OVER clause has been enhanced to calculate running tota......
|
|
-
19
Liked
| 17
Learned
| 8
Comments
|
|
The WRITETEXT statement is used to update a column of datatypes text, ntext and image. However it will not fire INSERT or UPDATE triggers......
|
|
-
18
Liked
| 17
Learned
| 4
Comments
|
|
[code]
The maximum number of parameters in a stored procedure is 2100.
The maximum number of local variables in a stored procedure is limited only by available memory.
Depending on available memory, the maximum size of a stored procedure is 128 megab......
|
|
-
19
Liked
| 17
Learned
| 6
Comments
|
|
KEEPIDENTITY applicable only in an INSERT statement when the BULK option is used with OPENROWSET. Specifies that the identity value or values in the imported data file are to be used for the identity column. If KEEPIDENTITY is not specified, the identit......
|
|