|
|
-
|
|
Security is the main thing for servers and sql servers and we need to trace it for security management. Have to need track who are using it, what they are doing and when they performed. For SQL Server 2005 and later versions we have some DDL events whic...
|
|
-
|
|
FOR /F : As we discussed earlier post it used same to traverse rows from generated file from SQLCMD command. Here we do not have values with delims (,) and we have only one values to grab and assign in variables.
forfiles.exe : It is used to delete f...
|
|
-
|
|
I wrote about my previous just learned tips about covering index and will publish my future post for the detail understanding it. We should generate index statistics and index usage report periodically, so we can have more idea of the index utilization....
|
|
-
|
|
In earlier post I have applied pivoting on one column name ItemColour but here I would like to introduce pivoting on more than one columns. So let us jump on example and implement it for multiple columns. Here below you can find the script to create req...
|
|
-
|
|
Here I am sharing the script to add foreign key on new/existing table/column.
...
|
|
-
|
|
Recently while working with database move to other location , I used tsql script to move them. There are some methods to move the database files to other like detach and attach files from new location and other one is with modifying database file locati...
|
|
-
|
|
We have seen example of Changing Rows to Columns Using PIVOT. Hope you liked that post and you enjoyed a lot also. As we know that we need to hard-code the values for pivoting which we have did for color values. for the values updates in table or whenev...
|
|
-
|
|
I set "DelayValidation" parameter of Send Mail Task to TRUE and then it skipped to validate existence of file at the beginning of file execution....
|
|
-
|
|
I just installed SQL Server 11 CTP3 in my machine and started to review new functionalities. One feature I learned is CONCAT(tsql function) which is used to concatenate two or more strings. This function requires 2 to 254 arguments....
|
|
-
|
|
EOMONTH is really intresting feature introduced by SQL Server 11 CTP3. It returns the end date of Month based on the passed date in query....
|
|