It has to do with the sequence in which SQL Server does things.

First, it tests to make sure it can compile the code. Then it tests to make sure...

And the times it won't work out are times the plan is likely to change anyway.

It's usually good enough to copy the database over to parallel hardware.

The thing to avoid...

I don't know that SSMS really does that. There are plenty of tools out there for it, but I don't think SSMS is one of them.

It's been a few years since I worked with Access-on-SQL (sounds like that should be the name of a village in England), but if I remember correctly, the key thing...

I did the opposite, in a way.

Went from management/supervisor roles, into sales/marketing, and then into IT.

The key thing to know in any management position is how to deal with communications...

The first step is to build a Select statement that will get all the ones you want to exclude directly or indirectly.

select *

from MyTable

where ip = '1.1.1.1'

or wordtexts = 'tokyo';

Then...

Stefan Krzywicki (2/1/2011)

Brandie Tarvin (2/1/2011)

I haven't moved up to SQL 2k8 yet, so haven't...

You're welcome.

I actually learned about that from an SQL injection technique that was in heavy use a few years back. Was hiding the SQL commands inside a binary string,...

The way to find...

Snapshots are copies of the whole thing.

Check data here for details: http://msdn.microsoft.com/en-us/library/ms187054(SQL.90).aspx

Select from the parent table, and use an inline sub-query to get the phone numbers, using the For XML trick in that.

select *, (select phone from MyPhones where Person =...

Ditto

The usual way I do this in SSIS is with a For Each Next loop. You can either loop through the contents of a directory, or through the rows...

Start with:

select *

from sys.syslogins;

That will give you a list of the logins.

If you look that up in Books Online or on MSDN, it will have links to related items, which...

I just tried this:

DECLARE @XML XML = '<row ID="1" /><row ID="2" />', @Bin VARBINARY(MAX);

SELECT @XML;

SELECT @Bin = CAST(@XML AS VARBINARY(MAX));

SELECT CAST(@Bin AS XML);

From that, I tried this:

CREATE TABLE dbo.DropMe (

ID...