Actually, the only way you can guarantee the order in which SQL Server will return the rows is to use the ORDER BY clause. All SELECT statements without an...

Yes, the TRUNCATE TABLE command will fail if the table has a foreign key referencing it. You must either drop the FK or use the DELETE statement.

The conflict is probably comming from the data/log file locations. Did you change the paths for these files before attempting to restore?

I would go with Suresh's suggestion...

Well, here's the catch. You can't create a global temporary table without explicitly using the CREATE TABLE ## statement. So how, when they create the table, do they...

From a best practices standpoint, I'd shy away from using global temp tables. They cause more headaches than help. What exactly are you trying to do? Can...

Wow, that's scary.

How you do this depends on a couple of factors. How many rows are in your table? How many rows are dupes that need to be deleted?

Not to bore you with the details, but there is a chance that deleting a log file can result in lost data. All data modifications are written to the...

Jeff, Do you have documentation to support that SQL Server behaves that way? I've never heard this before. Are you saying that if you create a new DB...

Well, your using SQL Server 2000 so you can't take advantage of a CTE or any of the new ROW_NUMBER() or ranking functions.

You'll need a way to order...

Great topic! Most folks are moving backwards financially. We see it with today's economy, rising fuel and food costs, increased home forclosures. People have been living above...

And to expand on what Rudy has said, because the rows themselves are not affected until a modification takes place, this whole scenario changes if you add the columns NOT...

Good one Gus, well presented. Looking forward to reading the second article.

Ah, sorry. I misunderstood you question. Why does it have to be in a LIKE clause? Why not CHARINDEX?

declare @table table (col1 varchar(100))

insert into @table

select 'this value...

It should work just like it has in prior versions unless I've missed something. Can you give us an example of some T-SQL that you've ran where it has...