Viewing 15 posts - 15,121 through 15,135 (of 39,970 total)
Poll on Dan Patrick this morning: Who gets back in the groove first? A-Rod or Tiger?
I was thinking Tiger, but Rich Eisen thought that Tiger might never win again....
October 7, 2011 at 8:53 am
Ray K (10/7/2011)
Steve Jones - SSC Editor (10/7/2011)
Didn't see the game, but sounds like lots of drama in there.
I had the game on in the background. There were too...
October 7, 2011 at 8:52 am
jay holovacs (10/7/2011)
October 7, 2011 at 8:51 am
You're looking at this the wrong way. You can tune a SQL statement to use less records, usually with indexing or rewriting.
This use of TOP doesn't make sense.
October 7, 2011 at 7:54 am
AFAIK, the UCP collects data using Data Collector from other instances. This provides an overview, which seems to indicate that it might supercede DC, but it might just be a...
October 7, 2011 at 7:52 am
I think you can write a query that gets these values from the table.
You could so something like
select orderID, itemID
from Orders o
where ItemID > 'I3'
However if you could...
October 7, 2011 at 7:48 am
Sean is correct. Without an order by, the top 10 is semi-useless. You might get different sums each time.
October 7, 2011 at 7:43 am
This help? http://msdn.microsoft.com/en-us/library/bb675163.aspx
Explains the process and shows C# code.
October 7, 2011 at 7:41 am
There's a basic diagram in SSMS, though it doesn't to HTML. However you could take an image and HMTL map link it to docs.
I used to use ER/Studio for something...
October 7, 2011 at 7:34 am
Not asking that at all, just strange that everyone dropped off at once.
I'm sure a few of you are heading to PASS or SQL Saturday #92 in Portland today, but...
October 7, 2011 at 7:31 am
Send the encryption password separately from the drive. If the drive is lost, the key to get in shouldn't be in there.
October 7, 2011 at 7:30 am
amazing how this thread will explode or go dead in a cycle. Everyone watching Tigers/Yankees last night? Or the new Big Bang Theory?
October 7, 2011 at 7:20 am
Congrats to the Tigers.
Didn't see the game, but sounds like lots of drama in there.
October 7, 2011 at 7:14 am
Which event? The events are linked in the editorial.
October 6, 2011 at 10:32 am
First do this:
1. create a new role
2. Grant delete to this role.
3. create a new user/login, add them to the new role
4. see if they can delete.
That tests the...
October 6, 2011 at 10:31 am
Viewing 15 posts - 15,121 through 15,135 (of 39,970 total)