i'm lazy and use the GUI for it

go to table, right click and design. select the column and on the bottom is the option to add identity

have you tried to use varchar(max) instead of 8000?

ok

i remember i had the R2 and it popped up in green when i did the execution plan. boss had SQL 2008 SSMS and he said he never saw it....

thx, going to have to check this out. problem seems to come and go. only thing is i don't think we do any file system backups of SQL servers

gary.strange-1058508 (7/22/2010)

---

Some of the comments posted seem to be following the lines of "what if this, what if that, this isn't quite right".

I would agree that the article may leave...

bob.taylor (9/16/2008)

---

And in SQL Server 2008, it gets even easier. When you display an actual execution plan in SQL Server Management Studio query windows, you will receive a message in...

thx

as soon as i got rid of that quote it went further than line 3 and to line 41. now i have to check the entire file which is over...

is there a way to do it within SSIS using the transformations? i want to change some data types to other that string types and it would mean i would...

when i upgraded our netbackup software i turned on checksum for most databases and didn't see any impact, but didn't do too much of a scientific study

to get the pages...

are you getting errors in the SQL log about memory being cached out? we had that until we put in lock pages in memory

it has to insert it in the right place in the clustered index, so it has to look up where to insert it to

my memory is not as good as it used to be, but i don't think you can do it using dynamic SQL. i think i tried this one time a...

have you run a trace?

we used to have a developer who loved views. he created them for everything even if they only returned a few rows. when i had to troubleshoot performance issues with...

the database in question is for Symantec's anti-virus management product. they needed a copy for a case we had open so i restored it to QA and tried to shrink...