Viewing 15 posts - 38,476 through 38,490 (of 49,571 total)
The list's just the spotlight sessions, those were invitation only. If you submitted a general session you should have got an email last night (assuming they weren't sending in batches)...
June 13, 2009 at 12:17 pm
Change your counts to sum or change your 0 to NULL
Count counts the number of rows, it doesn't care if the values in those rows are 1 or 0, either...
June 13, 2009 at 11:36 am
Jeff Moden (6/13/2009)
Or would that turn into a ring knockers club?
Maybe, but even if it doesn't, there'll still be the sense of elitism about it and there'll still be people...
June 13, 2009 at 11:31 am
dxmer (6/13/2009)
Wow, a further explanation that doesn't address the question.
Ok, since I apparently can't read and have limited ability to comprehend English, will you repeat, for the record, what your...
June 13, 2009 at 11:21 am
Jeff Moden (6/13/2009)
Heh... I've found that many concurrency issues simply vanish in the presence of high speed code.
Agreed. If the queries are running faster, they're locking for shorter periods...
June 13, 2009 at 10:21 am
Check the script library here, there are lots of index rebuild scripts there that satisfy your requirements.
June 13, 2009 at 10:17 am
Thanks. 😀
I'm presenting two sessions this year, one spotlight and one general (with my 3rd submission marked 'alternate'). I've got one confirmed full session at TechEd Africa as well, plus...
June 13, 2009 at 10:17 am
Use sys.indexes instead of sysindexes and you can get the index type as well from the column type_desc. For the columns that comprise the index, join in sys.index_columns
June 13, 2009 at 8:25 am
Sergiy (6/13/2009)
I did not find anything in the article which would contradict my point.Or was it in support?
No, it's in contradiction. I do not and never have agreed with the...
June 13, 2009 at 7:55 am
You can never view the estimated exec plan for a proc that creates and uses a temp table. The temp table doesn't exist at compile time, so you get the...
June 13, 2009 at 5:36 am
Aaron (6/13/2009)
**** Can I set READ UNCOMMITTED to write asynchronously to thie "buffer" (current) table?
The READ UNCOMMITTED isolation level only affects locking by selects. All data modifications will still lock....
June 13, 2009 at 5:06 am
Which line of code's throwing the error and what's the complete error message?
p.s. SA login and a simple password? I hope that's not what your system's actually using....
June 13, 2009 at 5:02 am
More information please. Where was the backup taken from and how was it taken? Where's the backup been restored to and what's the statement that you're running?
June 13, 2009 at 4:44 am
What do you mean by 'cannot view execution plan'? If you run the proc in management studio with the "Include Actual Execution Plan" option selected, what happens?
June 13, 2009 at 4:40 am
See yesterday's headline article for info on posting performance problems
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 13, 2009 at 4:40 am
Viewing 15 posts - 38,476 through 38,490 (of 49,571 total)