Viewing 15 posts - 1,576 through 1,590 (of 5,590 total)
Gianluca Sartori (4/1/2011)
Congrats, Paul!And thank you for the infinite times I learned something from you.
I concur... I have learned so much from you. (And thanks for your patience in...
April 1, 2011 at 1:40 pm
Where is the MVP list of recent awardees? (I'm not gonna get burned today - I'll verify it first!)
April 1, 2011 at 9:48 am
GSquared (3/31/2011)
I seriously can't believe Celko did this: http://www.sqlservercentral.com/Forums/Topic1087228-61-1.aspxI'm seriously hoping it's followed up with "April Fools!" or something. Just, wow, if not.
Cute.
First clue: time of post.
April 1, 2011 at 9:44 am
ptlbiren (3/31/2011)
WayneS (3/31/2011)
ptlbiren (3/31/2011)
Msg 8115, Level 16, State 6, Line 14
Arithmetic overflow error converting varchar to data type numeric.
And also correction in above update statement...
March 31, 2011 at 9:54 pm
repent_kog_is_near (3/31/2011)
can proc return back table of data (like function)- can you provide a small example?
I'm not sure if I'm misreading this question, or the others are. But what I'm...
March 31, 2011 at 8:13 pm
Just shooting from my hip here... I know that Linked Servers (and the OpenRowset/OpenDatasource) utilize RPC calls. Frequently when working with tables via Linked Servers, the local server end up...
March 31, 2011 at 8:07 pm
The most recent code for shredding the Deadlock Graph is located here.
March 31, 2011 at 7:52 pm
ptlbiren (3/31/2011)
Msg 8115, Level 16, State 6, Line 14
Arithmetic overflow error converting varchar to data type numeric.
And also correction in above update statement it is...
March 31, 2011 at 7:50 pm
Jeff Moden (3/31/2011)
Craig Farrell (3/31/2011)
Grant Fritchey (3/31/2011)
Craig Farrell (3/31/2011)
Grant Fritchey (3/31/2011)
March 31, 2011 at 4:07 pm
I was asked a question a few minutes ago by a developer. Didn't want to laugh in his face, primarily because he didn't believe this either. But at his last...
March 31, 2011 at 3:36 pm
WayneS (3/31/2011)
CirquedeSQLeil (3/31/2011)
@Wayne - did I miss something? What's up with the SQLRally logo in your sig?It's the "I'm attending" logo, not the "I'm speaking" one.
Well, now it's the...
March 31, 2011 at 2:22 pm
CirquedeSQLeil (3/31/2011)
@Wayne - did I miss something? What's up with the SQLRally logo in your sig?
It's the "I'm attending" logo, not the "I'm speaking" one.
March 31, 2011 at 2:18 pm
Stefan Krzywicki (3/31/2011)
Craig Farrell (3/31/2011)
Stefan Krzywicki (3/31/2011)
Chad Crawford (3/31/2011)
Kiara (3/31/2011)
March 31, 2011 at 1:35 pm
opc.three (3/25/2011)
In the absence of a defined clustered index SQL Server will use the PRIMARY KEY as the clustering index.
Not so. A table either has a clustered index (clustering table),...
March 31, 2011 at 10:22 am
giles.clapham (3/25/2011)
Insert @InactiveContacts (CID)Select distinct e.CID
from @AllActivity AA
Left Join @ActiveContacts A on a.CID=AA.CID
Where a.CID is null
Remember that with table variables, SQL can't create statistics, so it knows nothing about...
March 31, 2011 at 10:17 am
Viewing 15 posts - 1,576 through 1,590 (of 5,590 total)