Viewing 15 posts - 3,841 through 3,855 (of 14,953 total)
I can't get it to do precisely what you're describing.
I do get the empty Object Explorer, but I don't get any scripts/connections re-opening. Am I misunderstanding what you mean...
July 1, 2011 at 12:34 pm
No. The catalogue is simply an object container now. The indexes are still stored in their own space (essentially).
July 1, 2011 at 11:19 am
SQLRNNR (7/1/2011)
GSquared (7/1/2011)
Jim Murphy (7/1/2011)
Oh, in case everyone didn't hear: Congratulations Gail for making MVP again!
In other breaking news, the sun rose in the east, and there's a chance of...
July 1, 2011 at 11:17 am
opc.three (7/1/2011)
July 1, 2011 at 11:07 am
Jim Murphy (7/1/2011)
Oh, in case everyone didn't hear: Congratulations Gail for making MVP again!
In other breaking news, the sun rose in the east, and there's a chance of rain in...
July 1, 2011 at 11:05 am
GilaMonster (7/1/2011)
GSquared (7/1/2011)
July 1, 2011 at 11:03 am
GilaMonster (7/1/2011)
Gus, you own me a new keyboard!GSquared (7/1/2011)
I must be misunderstanding you. I've never before seen someone recommend hypocrisy before without it being essentially sarcastic.
Assuming "own" = "owe",...
July 1, 2011 at 11:00 am
The main advantage I see to the non-clustered index in this case, is that it will have more rows per page than the clustered index (since it's narrower), and if...
July 1, 2011 at 10:58 am
GilaMonster (7/1/2011)
http://www.sqlservercentral.com/Forums/FindPost1135189.aspx
Writing scripts for admin purposes is not development? Really?
"Practice and Recommendation are 2 different things" Really? Is 'Do...
July 1, 2011 at 10:53 am
Syed Jahanzaib Bin hassan (7/1/2011)
Yes, it's bad practice. Sysprocesses is deprecated, it's a compatibility view solely for old code written for SQL 2000
Practice and Recommendation are 2 different things,Here we...
July 1, 2011 at 10:51 am
krish.sett (7/1/2011)
Hi Gail Shaw,So you mean to say its another way of appling unique constrain ...?
It's actually how unique constraints are done by the database. Same thing.
July 1, 2011 at 10:44 am
Normalize it. I've managed a database like that (REO properties industry), and the "never been normalized" version (can't call it "denormalized" if it was never normalized in the first...
July 1, 2011 at 10:43 am
krish.sett (7/1/2011)
In my current Project most of the tables have NonClustred index on Primary Key.
please let me know what is the advantage of having NonClustred Index on Primary Key
And...
July 1, 2011 at 9:11 am
How is it denied?
Have you denied it by placing it in an AD group that is denied at the login level?
Is the login itself listed as a login in SQL...
July 1, 2011 at 9:07 am
Viewing 15 posts - 3,841 through 3,855 (of 14,953 total)