it sounds like all the instances(2008, 2008R2, and 2012) are all on the samemachine.

you will absolutely have to change the path or filename in order to have more than one...

performance is really a broad quesiton, and it's not just procedure codign style you need to consider;

indexing and SARG-ability of the queries are probably the two biggest things i would...

the question sounds a little bit like a turf war...don't want the dba to have full access to the box?

the answer is it makes my job substantially harder if i...

smacking myself in the head!

I didn't think of using FOR XML to handle the concatenation; that, sir, is beautiful and inspired.

You'd think i'd know better, so double kudos to...

what you really want to do is a side by side server upgrade.

on the 2008 server, you script out stuff, and run the scripts on the new server. no restoring...

this is typically dones via Reporting Services or a third party tools.

I've done it with a web service that cosumes a dataset and returns a binary blob, which cna be...

looks like you posted actual or peudocode from MySQL, I'm guessing?

In SQL Server, you'd have to use a procedure or a batch of code; functions are reserved for read access...

you could consider creating an easy way for some of the most prolific volunteers on the site to be able to feed a post to something for an automated removal;...

check the size of the table; small tables under something like 1000 pages of data will not be affected by a reindex. that could be what you are seeing: small...

i've used Test-Path to see if files or folders exist, and make a decision from there to do my logic; create files, process files, copy them or whatever.

#the detail file...

There are 8000 files on the ftp site and you dont want to remove them from the site itself?

You really need to do one of the following :

1.remove them...

I'm with Lempster;

you have to either keep track of everything already processed in a database table or some otehr source, or move files that were processed to a different location(the...

what happens when you include the shcme aname explicitly?

select schema_name(schema_id),name, object_id (base_object_name),object_id (schema_name(schema_id) + '.' + base_object_name) from sys.synonyms

another thing i noticed, that was minor, but affected me nonetheless:

2008 has better exports to excel: it is able to name worksheets, and a report that had data that started...

small world, i just had to do this as well.

my hiccup was my original target server was 2008 standard, and not Enterprise, so i migrated reporting services, but the subscriptions...