The STUFF function
While I was at the 2011 Pass Summit I was given the following piece of code to create a comma...
2013-03-14
879 reads
While I was at the 2011 Pass Summit I was given the following piece of code to create a comma...
2013-03-14
879 reads
If you are lucky you’ve never seen an error along the lines of:
The SELECT permission was denied on the object...
2013-03-04
988 reads
I was scanning http://dba.stackexchange.com and ran across the following question:
http://dba.stackexchange.com/questions/31478/sql-server-script-to-delete-accounts-no-longer-in-active-directory
Basically the OP wanted to know how to get rid of...
2013-03-12 (first published: 2013-03-01)
4,151 reads
The INSERT command has two distinct ways to load data into a table.
INSERT INTO Table (field1, field2) VALUES ('string1','string2')And
INSERT INTO...
2013-02-28
3,368 reads
When writing a script to change a piece of code, say a stored procedure or view, there are 3 basic...
2013-03-05 (first published: 2013-02-25)
5,004 reads
Anyone who has been reading my blog for a while should realize that several divisions in my company have been...
2013-02-18
1,008 reads
For those who don’t know, the stored procedure sp_rename allows you to change the name of a user-created object. Basically...
2013-02-11
2,333 reads
The other day one of the developers I work with gave me a script similar to this:
BEGIN TRAN
sp_rename 'tablename.columnname', 'newcolumnname'
COMMITHe...
2013-02-06
759 reads
I recently got the following email:
“I just keyed in two rows into a table with all identical column values. How...
2013-02-11 (first published: 2013-02-04)
3,245 reads
We got a call last week about an application that was running slowly. The server was showing about 80% CPU...
2013-01-30
1,246 reads
By James Serra
(Shameless plug: The price of my book “Deciphering Data Architectures: Choosing Between a Modern...
By Steve Jones
I was working with a customer and discussing how to do error handling. This...
By DataOnWheels
The 14th annual Ability Summit is a global event that I attended a few...
Hello, I was given this SQL question and was hoping someone could please help...
In recent days past, there was a Performance gain by placing data files, log...
Ok, I've come up with another problem in my project. I am happily pulling...
How does the Resource database in SQL Server 2022 get backed up?
See possible answers