Moving Databases to a New Server
Got a plan for moving your data to the new server? Try this one! Andy Warren offers step by step instructions on how to move your data without doing a backup/restore or using detach and attach.
Got a plan for moving your data to the new server? Try this one! Andy Warren offers step by step instructions on how to move your data without doing a backup/restore or using detach and attach.
The eighth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
This week, Brian Knight reviews the book Gurus Guide to Transact SQL.
This article shows you in a step-by-step manner how to restore the master database.
The seventh part of Steve Jones's series on having SQL Server automatically report information to a DBA.
I ran into a dilemma when I was told that I should not allow potential competitors to view my JavaScript comments. If they want to figure the code out; make them work for it.
The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
This humorous form was originally desgined for Network Admins, but it works for DBAs as well.
Everyone needs a stable environment. This article discussed ways to keep your team on the same page.
The fifth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
Ready to dive into the world of SQL? Whether you're dreaming of a lucrative...
This comic was retweeted into my timeline on Twitter (I refuse to call it...
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it,...
Comments posted to this topic are about the item Creating a CSV Parser in...
Hello experts, We set up the Brent Ozar SQL Agent alerts, one of which...
Hi as you can see at https://www.sqlservercentral.com/forums/topic/test-sql-servers#post-4422832 we would really like multiple instances in...
I want to enable two trace flags, 4199 and 4137, for a single query. How should I do this:
-- A SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, 4137); -- B SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, QUERYTRACEON 4137); -- C SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199), (QUERYTRACEON 4137);See possible answers