don't try to do it in the table. create a view or query that uses row_number() OVER (Partition by...order by..)

if you try and do it in the table itself, you...

well I'd say go with rebuilding all your statistics as well first,a dn then start looking at specific slow performing queries,a dn whether you can either get indexes in place...

well, i'll throw my two cents in, and you can evaluate them for yourself

i can only tell you my experiences and the way we do things at my shop; you...

If you need the schema and the data, the "number 1 doctor recommended " way todo that is via backup and restore;

it's flawless, and is either pass or fail; you...

it depends on whether the developers are allowed to do DDL changes, and how often those changes need to be re-applied when you refresh.

with regular restores, the develoepr changes get...

in a similar post a couple of years ago, i did a TSQL example that looked at the first x bytes and compared them to known values to find gif/jpg/bmp/png...

i don't think you really need the database at all.

I'd create a job script for the client, nad ask the client to add a job or two , that runs...

quackhandle1975 (3/4/2014)

I am looking to perform some DBCC CHECKDB tests and for many reasons, I cannot copy a use a copy of current prod database, but the best I can...

is it possible tha that the file being read is still being written by some other process , and you are accidentally grabbing it mid-stream? i know i had an...

also, if your table variable has more than a few hundred rows, switching it to a temp table allows SQL to use automatically created statistics on that table in order...

i believe it's bad syntax, which can result in an accidental cross join.

you are updating a table variable, but it is ALIASED elsewhere; because it is not explicitly named, there's...

there's a session-level value named CONTEXT_INFO you could set, but you would have to modify your application to set it and use it;

here's an example or two:

DECLARE @var VARBINARY(128)

SET @var...

TSQL pretty much limits you to looking inside databases. For anything outside of a database , in your case FTP and files, i think i'd create an outside process to...

to go that deep, you'd need to execute the procedure, capture the execution plan, and parse the xml out to get it down to the column level;

the queries in the...

nope.

in 2005, i believe only actual objects that...