Viewing 15 posts - 3,976 through 3,990 (of 18,926 total)
If we don't want to "win" SM. Can we pick another tool?
August 2, 2011 at 11:51 am
Can you enable snapshot isolation and put tempdb on it's own set of drives?
They will be able to run at the same time and NOT wait on locks... and split...
August 2, 2011 at 11:49 am
The duplication is CODED within SSMS GUI.
Don't use the GUI, use a script and you'll see exactly what the server will do.
August 2, 2011 at 11:46 am
PaulB-TheOneAndOnly (8/2/2011)
sravnmaganti (8/2/2011)
actually i want to know is it possible to create primary key with non_cluster index.Yes.
Edit: man, you are fast
I know, and it's about time you realized it too...
August 2, 2011 at 11:45 am
Bingo, you've found one of the hidden "features" of ssrs. Wreaks havoc with dates too (if your ssms settings are different than Bids when you copy queries from profiler...
August 2, 2011 at 11:43 am
GilaMonster (8/2/2011)
Ninja's_RGR'us (8/2/2011)
So Gail, how did the conversation end?With my account untouched.
:w00t:. That must have been a tough pill to swallow for the CSR ;-).
August 2, 2011 at 11:26 am
sqlfriends (8/2/2011)
I just heard before is to avoid using Cursor, so now I understand in some way cursor is good for admin...
August 2, 2011 at 11:25 am
Don't use the GUI.
It'll never create another table unless you code it.
As for DO NOT USE, I preffer just dropping the column. Not 100% sure about the impact on...
August 2, 2011 at 11:22 am
GilaMonster (8/2/2011)
Ninja's_RGR'us (8/2/2011)
calvo (8/2/2011)
Steve Jones - SSC Editor (8/2/2011)
I used about 500-700 minutes a month, and about 350-400GB of data + who knows how much on wifi.
Ahh... that explains the...
August 2, 2011 at 11:21 am
sqlfriends (8/2/2011)
Just to show how to filter... and how overly complicated it can be in ForEachDB >>So do you mean Cursor in this case is easier?
Thanks
You tell me. Took...
August 2, 2011 at 11:16 am
Make a new AD group call ArchiveRead or something like that.
Go through the pain of the setup once and then forget about it.
August 2, 2011 at 11:15 am
calvo (8/2/2011)
Ninja's_RGR'us (8/2/2011)
calvo (8/2/2011)
Steve Jones - SSC Editor (8/2/2011)
I used about 500-700 minutes a month, and about 350-400GB of data + who knows how much on wifi.
Ahh... that explains the...
August 2, 2011 at 11:14 am
george sibbald (8/2/2011)
DBCC memorystatus but good luck with that. 🙂
Holly ****.
414 rows affected on my system :sick:.
So when you said good luck, what did you really mean?!? 😉
August 2, 2011 at 11:11 am
Viewing 15 posts - 3,976 through 3,990 (of 18,926 total)