Who Do You Hire?
This article examines the hiring practices of Steve Jones and provides some ideas for how to choose between candidates.
2001-06-22
13,497 reads
Articles
2001-06-20
3,674 reads
Job to Monitor SQL Server 7.0 Performance and Activity
This article describes the ActivityTrace7 job that puts blocking and performance data into a trace file for further analysis.
2001-06-19
2,670 reads
2001-06-18
2,028 reads
Installing Service Pack 1 for SQL Server 2000
Like most SQL Server service packs, the latest service pack by Microsoft for SQL Server 2000 is simple to install. Don't let this deceive you though. A step mishap can leave your system in an inconsistent state and cause major problems when users begin to hit it again. This article will provide you a step-by-step guide to installing Service Pack 1 for SQL Server 2000.
2001-06-18
5,449 reads
Notes from the field - SP1 Personal Edition
Steve Jones provides some notes from the field after installing SP1 on a personal edition of SQL Server
2001-06-18
2,894 reads
2001-06-15
7,478 reads
2001-06-14
5,684 reads
Executing Multiple Scripts in a Folder using the ScriptRunner Utility
Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze.
2001-06-14
10,297 reads
Security Alerts and Information
A new security alert affecting SQL Server was released on June 12, 2001
2001-06-14
3,635 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers