It sounds as if you've done about all you can do to optimize SQL2K to work with T-SQL cursors (server-side cursors). Client side cursors will be a whole lot...

Dale, look in BOL on how to create new templates. However, right clicking on the table in the SQL2K object browser, selcting Script to New Window -> Insert will...

If the data is in the same table, you could group by the week and year:

SELECT 

    DatePart(yyyy, DateField) as "Year"

  ,...

Great find, rstone!

See SQL2K QA's INSERT INTO template...

Here's one argument against it, for devil's advocate sake. Sometimes, when doing performance tuning there are multiple ways to refine a particular query that can lead to different execution...

You are on the right track with Frank's reply. Just wanted to point out to watch out for the ampersands in your original procedure. The concatenation operator in...

Agreed. MS Access has some great tools to enable quick query building. But here's one for you: ever tried scraping the SQL out of Access' SQL view (clicking...

Dale. You are right. Although I have never myself actually used the Query Builder in EM to build a query I did confirm that the Change Type ->...

quote:

---

Like this:

insert #t exec('dbcc inputbuffer(' + '@who_spid' + ')')

?

---

Almost:

insert #t exec('dbcc...

Between TEXT and NTEXT: if you predict or absolutely know that your data will contain UNICODE characters, use NTEXT. Otherwise, DON'T, use TEXT.

--

Regarding parsing it out: Really the...

Actually, I just noticed what it is: if you use the variable in the EXEC statement you need to put together the SQL string for DBCC INPUTBUFFER by concatenating the...

Check to see that you haven't got a GO statement somewhere...it'll end the batch and put the variable declarations out of scope.

If you want to find the space used by the table, check out the dpages column in sysindexes. It stores the number of extents used by the table (heap...

Note quite sure what you mean by "collate the number of columns", but you may want to join on syscolumns to find information on the columns involved in the table...