Detaching Databases - SQL School Video
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.
Identifying Queries Running Slower Than Normal
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.
Multiple Server Queries with SSMS 2008
This short article shows how to run the same query against multiple servers and aggregate the results into one set with SSMS 2008
The Training Value
Training is something that Steve Jones believes in for an successful IT career. However this Friday he asks how much should your employer help.
The Training Value
Training is something that Steve Jones believes in for an successful IT career. However this Friday he asks how much should your employer help.
The Training Value
Training is something that Steve Jones believes in for an successful IT career. However this Friday he asks how much should your employer help.
Using SQL Servers OPENROWSET to break the rules
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?
Snooping
System administrators have a lot of power and temptation to use it. Steve Jones talks about the need to resist temptation and the need for oversight.
The Top Ten Reasons to Attend the PASS Summit 2008
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.
A Release from Data
What do you do when work is too frustrating. Steve Jones talks about finding a way to release stress and frustration.
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Everything is the right question away
Comments posted to this topic are about the item Everything is the right question...
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers