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
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,152 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,006 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
989 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,375 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
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
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,334 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
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
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
I have joined a new project, where the business uses Azure SQL Hyperscale for...
Dears, Hope this message finds you well I did not see in this foruns...
The below code works for backup files only from local drives. When replaced with...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers