Jeff Moden (12/16/2008)

---

Did that too. The most difficult stuff to judge is kata... it's like judging a dance competition... put all the flair and flash in that you want,...

OK. First off, don't collect StmtComplete events as part of a general data collection process. They are for targeted troubleshooting only. Second, I wouldn't worry overly much about the logout...

It's worth mentioning, since you're building a repeatable and well defined process around moving data out of the system, I'd suggest looking at partitioning the table. Partitioning would allow you...

Human beings do not look at 200000 rows worth of data... ever. So, you need to identify the data that is actually needed for the report, the last day's worth...

Also, rather than have one of use write the entire query for you, show the work that you've tried, even if it doesn't work, and then we can help correct...

stratergib_77 (12/16/2008)

---

Hi, I'm building a web application that uses sql server for my database. This database holds student information, course information, student grades, etc. Currently I have my student table,...

Jeff Moden (12/15/2008)

---

Must be something else... I raised two kids... even did the Cub Scout and Boy Scout thing and a whole bunch of other things that gave me a...

At least he made it easy for you:

Wait, wait... I'm confused.

We had tracks?

Itzik Ben Gan's new one, SQL Server 2008 T-SQL Fundamentals. Almost all of it will be applicable to 2005. After you finish that one, pick up his older book Inside...

Well, I didn't just tumble out of a Vault, you know.

I agree with Jack on this. SSMS is a pretty good tool, but you don't have to use it. As a matter of fact, you might be much better off...

It means the process itself still has work to do, but it's waiting on something. BOL refers to blocking as a possible cause.

Is the field a number field, int, bigint, numeric, decimal. If not, it won't allow you to create an identity.

I'd strongly suggest you use Matt's solution. The one you have is going to perform pretty badly.