The short answer: No.

You'd want to consider placing multiple instances on the machine if you wanted to be able to split the memory. Then you could give one instance...

You can find it in the downloads section at http://www.microsoft.com/sql. SSIS is SQL Server Integration Services and is the replacement for DTS. WMI is Windows Management... (something,...

Hahahah...

the reason I developed the technique for parsing string data like that is because I have an ODBC connection to a progress database. Progress is dumping the data down...

Usually I've seen this controlled via triggers.

I don't especially like ERwin, though it's the long-standing standard where I work so I'm forced to use it. But in Visio you can turn on crow's feet by...

That's one of the reasons the article is on hold for now... I did some performance comparisons and found that in many cases it's actually better performing to use...

You might be able to apply some of the same principles I used in my article to your situation:

http://www.sqlservercentral.com/columnists/aingold/workingaround2005maintenanceplans.asp

I'd say capture all the backup file names into a table and...

You need to group the OR clause with parenthesis:

...

and ( vendor_code like '10%' or vendor_code like '20%' )

Otherwise it sees all the possible AND statements, but because the vendor_code like...

Change the last line to this:

on e.employeeID = convert(int, c.emp_id)

where depth > 0

This is rough but it is adapted from a technique I've been working on for an upcomming article. A common table expression is an excellent way to parse short...

You probably need to read up on ANSI_NULLS settings in BOL (or http://www.sqlservercentral.com/columnists/jtravis/understandingthedifferencebetweenisnull.asp). Evaluating anything against nulls can be tricky and depending on your settings the select statement could...

Well let me know...

The logic is that if @variable = 'x' then it will apply the rest of the AND conditions within the parenthesis. However if @variable is not...

This should do it:

SELECT *

FROM table

WHERE (@variable = 'x' AND other_condition = 'foobar')

OR ISNULL(@variable, 'anything other than x') 'x'

The ISNULL() is important because otherwise if @variable is null the...

No problem man, I've had a lot of people answer a lot of my questions over the years.

If you need to get it out to a text file you've got...

Ken Henderson does something like this in his book "The Guru's Guide to Transact SQL" by creating the objects within the master database and giving them the prefix "sp_". ...