Creating SQL Objects on the fly with VB and XML
A method for creating databases and other objects on the fly and distribute these objects to multiple servers.
2001-06-08
1,944 reads
Articles
Speed Tips For Select Statements
This article by Neil Boyle examines techniques for speeding up your queries by writing better T-SQL.
2001-06-07
13,657 reads
Professional SQL Server 2000 DTS Review
Steve Jones reviews the premier DTS reference for SQL Server 2000.
2001-06-06
12,659 reads
SQL Server 7.0 and OLE DB Heterogeneous Queries
This article discusses queries that involve more than one database server. For example, you can run a query that returns a joined recordset where some records come from a SQL Server™ database and others come from an AS/400 machine.
2001-06-06
1,416 reads
Speedy Database Recovery with Differential Backups
Differential backups are a new feature in SQL 7 that can speed up your recovery times when restoring from database and transaction log backups.
2001-06-05
7,684 reads
Microsoft SQL Server 2000 Reliability
Lots of people are designing and building Microsoft Windows-based apps with previously unimagined reliability. Starbucks, GMAC, and FreeMarkets.com all have case studies demonstrating five nines. So, how are these companies able to achieve these levels of reliability?This month I am going to show you how to use standard Microsoft Windows technologies to make your Microsoft SQL Server™ app just like Denny's—“always open” and ready for business.
2001-06-05
1,660 reads
Complex updates using the Case statement
One of the keys to database performance if keeping your transactions as short as possible. In this article we will look at a couple of tricks using the CASE statement to perform multiple updates on a table in a single operation.
2001-06-04
10,760 reads
2001-06-04
2,777 reads
Put Advanced SQL Server Features To Work
SQL is the lingua franca of server-side Web data apps. Some of the advanced features of SQL joins, views, rankings, and computed columns can drastically simplify your code.
2001-06-04
1,107 reads
Missing Temp Tables
In part one of a two part article, Andy Warren challenges the readers of SQLServerCentral.com to solve a problem involving ADO and SQL Server. Are you up to the challenge?
2001-06-01
4,312 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