Truncate data from all tables in a database
This script will truncate data from all tables in a database
2005-06-06 (first published: 2005-05-13)
469 reads
Grant EXECUTE permission to users
This procedure will assist in granting execute rights to a database user to all the stored procedures in a database The parameters to this procedure are the databasename and the username to whom EXECUTE rights need to be given to The assumption here is that the user already has access rights to the database mentioned […]
2005-05-05 (first published: 2005-04-19)
201 reads
Blogs
Sorting in Stored Procedures – Food for Thought
We know that sorting can be one of the most expensive things in an...
Trace Query in Extended Events
The ability to quickly and easily trace a query is important to database professionals....
Using Erik Darling’s sp_pressure_detector to resolve CPU issues
By DesertDBA
Last Friday I spent my lunch break going through some links I had marked...
Forums
How to import Excel with XML
Hi, I have an Excel sheet that I have to import into SQL Server....
Recursive CTE - Batches
Hi Folks I'm trying to group rows into batch and adding batch to query...
XQuery - Use column value to display correct node
Hi All First time with XQuery and despite trying to read as many guides...
Ask SSC