Viewing 15 posts - 43,021 through 43,035 (of 59,063 total)
Charles Kincaid (7/10/2009)
If you got Jeff, Joe, Andy, Phil, and Steve in a a single room the angels would not commence singing and no sparkly glowing would start.
Heh... I think...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 10, 2009 at 4:48 pm
Paul White (7/10/2009)
Sometimes, MVP = Mighty Vacuous PostSo I couldn't resist - sue me! :laugh:
Heh... there are 10 types of MVP's... those that know, and those that don't. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 10, 2009 at 9:54 am
Gaby Abed (7/10/2009)
2) be prepared in case Microsoft suddenly removes an undocumented feature in the next version of SQL Server (and sometimes even in the next Service Pack)
Shoot.... be prepared...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 10, 2009 at 9:52 am
apat (7/9/2009)
Hello All,How to find total number of tables in each database for all the databases on one particular server?
Thanks,
apat
I've seen this question from various folks over the years and...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 9, 2009 at 5:58 pm
In most cases (there are exceptions), claims to SQL by other than people interviewing specifically for SQL Developer or DBA usually mean that they were actually in the same room...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 9, 2009 at 5:56 pm
Duplicate post. Please don't post replies here. Instead, see the following URL...
http://www.sqlservercentral.com/Forums/Topic750661-146-1.aspx
--Jeff Moden
Change is inevitable... Change for the better is not.
July 9, 2009 at 5:38 pm
What type of object is qry_Healthstream?
--Jeff Moden
Change is inevitable... Change for the better is not.
July 9, 2009 at 5:11 pm
Just testing...
/**********************************************************************************************************************
Purpose:
Returns a single result set similar to sp_Space used for all user tables at once.
Notes:
1. May be used as a view, stored procedure, or table-valued...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2009 at 10:34 pm
GSquared (7/8/2009)
Here's the source for that: http://www.sqlmag.com/Articles/ArticleID/100697/pg/1/1.html (Subscription required)
But it's not on the official deprecations page, so far as I can...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2009 at 10:13 pm
That's also what I get from the article. I never do an order by that uses ordinals like that, but I see no reason for them to remove it.
There...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2009 at 10:12 pm
Jeff Moden (7/6/2009)
Where'd Digs go? He owes us a post with his solution...
Ok... it's been a couple of days. First things first... do you like pork chops? ...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2009 at 9:13 pm
WayneS (7/6/2009)
I'm pretty sure I know what your Tally table test is doing... but what is the difference between your "XML" and "XML2" tests? Would you be able to post...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2009 at 9:05 pm
It's a pretty good list... that's probably why the forum code listed it 3 times. 😛
Dev...make sure your developer have a list of best practices that won't kill your performance.
Avoid...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2009 at 7:52 pm
It would be interesting to see the complete code examples in the test harness you used.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2009 at 7:32 pm
So what's the advantage to prefixing every table name with "tbl"? I see it as a disadvantage just because it requires more typing. If someone with even a...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 8, 2009 at 7:18 pm
Viewing 15 posts - 43,021 through 43,035 (of 59,063 total)