Viewing 15 posts - 18,181 through 18,195 (of 22,202 total)
I have been working exclusively in the 2008 Management Studio for over a year now (beta's), so I don't remember 2005 real well, but 2008, the parenthesis highlighting is definitely...
February 26, 2009 at 5:36 am
RBarryYoung (2/25/2009)
Jeff Moden (2/25/2009)
February 26, 2009 at 5:31 am
I always suggest Itzik Ben-Gan's books, SQL Server 2008 T-SQL Fundamentals and/or Inside SQL Server 2005: T-SQL Programming.
Hey GSquared, Paul Neilsen is supposed to finish the 2008 version of the...
February 25, 2009 at 1:02 pm
Are you sure you don't have that backwards? It works in 2008 but doesn't in 2005.
That's because 2008 introduced intellisense and several other code formatting enhancements such as those little...
February 25, 2009 at 12:59 pm
Bob Hovious (2/25/2009)
It's not barrier to entry. Nobody has to take a test on the material. It's just something that first time...
February 25, 2009 at 11:50 am
Another vote for Red Gate's SQL Prompt. It's better than the intellisense in 2008.
February 25, 2009 at 9:37 am
I'm not sure why you'd have an index like that at all, but yeah, if each of those indexes is used independently by your queries, you will see a benefit...
February 25, 2009 at 9:36 am
Steve Jones - Editor (2/25/2009)
And yet one more example of things "getting worse"
Yeah, I've received one or two of those on my blog recently. It does seem like people are...
February 25, 2009 at 9:25 am
Chris Morris (2/25/2009)
Grant Fritchey (2/25/2009)
February 25, 2009 at 9:22 am
I agree with Jack and Barry. Yes, I try to post that way all the time. No, I don't think we need to get into sweating standards like that.
February 25, 2009 at 8:17 am
chrisau168 (2/24/2009)
I am reporting on a general ledger balance table, there are 110 million rows on this table. The reporting on this table to date has been very slow due...
February 25, 2009 at 5:53 am
You just won't get enough information from an article for stored procedure optimization. What you need is a book. I'd suggest Itzik Ben-Gan's SQL Server 2008 T-SQL Fundamentals or Inside...
February 25, 2009 at 5:41 am
I'm not sure I understand what you mean by "events." You can raise an error within a stored procedure and this will have to be dealt with by the client...
February 25, 2009 at 5:36 am
Alvin Ramard (2/24/2009)
hmmmm.....First there was The Thread.
Then came Son of the Thread.
NO!!!!!!
No, no, no, Bride of the Thread was next, then Son of the Thread, then Ghost of the Thread,...
February 24, 2009 at 4:09 pm
Everyone else has defined it already. You're getting RBAR because of the multi-statement UDF, not to mention that when you cross apply this query, it has no stats, so it's...
February 24, 2009 at 4:05 pm
Viewing 15 posts - 18,181 through 18,195 (of 22,202 total)