One very handy technique for dealing with the need to copy or move a database involves detaching the database from your instance. MVP Brian Knight shows how easy this can be to perform on your server.
2008-08-14
4,600 reads
The attached article describes a utility that allows you to quickly identify which queries are running slower than expected. Note this article was updated to correct the formatting issues.
2008-08-14 (first published: 2008-08-07)
24,792 reads
This short article shows how to run the same query against multiple servers and aggregate the results into one set with SSMS 2008
2008-08-14
5,919 reads
Training is something that Steve Jones believes in for an successful IT career. However this Friday he asks how much should your employer help.
2008-08-14
70 reads
Training is something that Steve Jones believes in for an successful IT career. However this Friday he asks how much should your employer help.
2008-08-14
70 reads
Training is something that Steve Jones believes in for an successful IT career. However this Friday he asks how much should your employer help.
2008-08-14
62 reads
Many times I would like to insert the results of a stored procedure into a table so I can do some extra processing with the result set. I always have to create the table first in order to perform an Insert Into Exec on the desired stored procedure since Exec Into is not an option. Is there a way to do this without having to manually create the table each time?
2008-08-14
4,696 reads
The PASS Summit is being held in Seattle on November 18-21, 2008. Read about a few of the reasons that you might want to ask your boss if you can go.
2008-08-13 (first published: 2008-05-01)
4,963 reads
What do you do when work is too frustrating. Steve Jones talks about finding a way to release stress and frustration.
2008-08-13
72 reads
What do you do when work is too frustrating. Steve Jones talks about finding a way to release stress and frustration.
2008-08-13
63 reads
By Kevin3NF
In parts 1 and 2 of this series, we’ve gathered info and done the...
By Steve Jones
At SQL Saturday Boston 2025, I gave a presentation on local LLMs and there...
By gbargsley
Are you diversifying your DBA skillset? My recent job search made one thing clear:...
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Comments posted to this topic are about the item Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers