Viewing 15 posts - 166 through 180 (of 820 total)
I have heared it as "Good, Fast, Cheap. Pick any two." See here. It's a truism. For the large part it's true. Like most truisms it's...
September 25, 2012 at 6:17 am
DB.Duck (9/17/2012)
CELKO (9/9/2012)
...we do not use BIT flags in SQL...You, sir, couldn't be more wrong. That is all.
Actually it's almost a great point but poorly stated. Let me give...
September 18, 2012 at 7:58 am
Ken,
It's a great article.
Yep as a simple teaching example I get your design. I also get what Joe is saying, although he has often said it better, in that...
September 10, 2012 at 1:04 pm
I just tried it again on my 2005 instance. Works fine for me but I do get that error if I don't have the following declare at the top.
DECLARE
@TABLENM...
September 10, 2012 at 9:10 am
Mick Opalak (9/5/2012)
Nice script, but can't you get the same information in Management Studio just by listing a database's tables in the Object Explorer and sorting by space used?
That might...
September 5, 2012 at 5:41 pm
thadeushuck (8/29/2012)
August 29, 2012 at 8:03 am
As for not having the source code, that might not be as big of a thing as you think. If you can extract the assembly as a file then...
August 23, 2012 at 6:43 pm
Great script. Thanks. I learned that all bets are off when change tracking is on. I had an express instance that reported full but space used showed...
July 11, 2012 at 9:08 am
I am proud of my homeland. I am also proud of being proud of my homeland.
Every person should be proud of their homeland. I like hearing from people...
July 5, 2012 at 9:29 am
GilaMonster (7/3/2012)
Any time at all that you query the index's order is irrelevant. Join or no join.
Sorry. I misspoke (mistyped, whatever). In the absence of ORDER BY it’s...
July 3, 2012 at 4:40 pm
GilaMonster (7/3/2012)
No. They define the logical order only.
The first time that you JOIN it won't matter anyway. There may be some ordering in intermediate result sets but the only...
July 3, 2012 at 9:55 am
So lets say that my application needs to connect. How do I construct the connection string?
May 23, 2012 at 2:57 pm
There is 1 central thing about stuff you can run as a SQL statment and that is:
It's a SQL statement. 😎
I have used the data access stuff just fine for...
April 27, 2012 at 12:46 pm
Say, Grasshopper, that remids me. COPY ONLY! Don't let a rogue backup mess up your chains.
Somebody else mentions log backups and differnetials. This thread is like a...
March 30, 2012 at 4:13 pm
I agree that there are lots of good tools on the market. What makes me so tired, and sad, is hearing from my clents that they have yet another...
March 30, 2012 at 3:36 pm
Viewing 15 posts - 166 through 180 (of 820 total)