New SSD (Solid State Device) hard drives are infiltrating enterprise servers more and more, but are they a good fit for database instances? Steve Jones comments a bit on some news from this past week.
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.
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.
This short article shows how to run the same query against multiple servers and aggregate the results into one set with SSMS 2008
Training is something that Steve Jones believes in for an successful IT career. However this Friday he asks how much should your employer help.
Training is something that Steve Jones believes in for an successful IT career. However this Friday he asks how much should your employer help.
Training is something that Steve Jones believes in for an successful IT career. However this Friday he asks how much should your employer help.
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?
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 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.
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
Whatsapp.083831617937 Ruko Prima Sunter, Jl. Danau Sunter Utara No.A2-A3 Jakarta Utara, DKI Jakarta, Indonesia...
Whatsapp.083831617937 Komp. Nirwana Sunter Blok A/31-32, Jl. Bisma Raya AsriJakarta Utara, DKI Jakarta, Indonesia...
Whatsapp.083831617937 Jl. Danau Agung 2 Blok E2 No. 1A, Sunter Podomoro Jakarta Utara, DKI...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers