Viewing 15 posts - 5,956 through 5,970 (of 9,399 total)
TomThomson (5/28/2015)
Eirikur Eiriksson (5/28/2015)
djj (5/28/2015)
Revenant (5/28/2015)
Ed Wagner (5/28/2015)
cunningham (5/28/2015)
crookj (5/28/2015)
Ed Wagner (5/28/2015)
djj (5/28/2015)
Ed Wagner (5/28/2015)
cunningham (5/28/2015)
sessionServer
SQL:-D
Performance
Recital
Piano
Guitar
Tune
Engine
Running
Races
Horse
May 28, 2015 at 11:30 am
No problem. Glad to help.
May 28, 2015 at 7:21 am
cunningham (5/28/2015)
crookj (5/28/2015)
Ed Wagner (5/28/2015)
djj (5/28/2015)
Ed Wagner (5/28/2015)
cunningham (5/28/2015)
sessionServer
SQL:-D
Performance
Recital
Piano
Guitar
May 28, 2015 at 7:20 am
djj (5/28/2015)
Ed Wagner (5/28/2015)
cunningham (5/28/2015)
sessionServer
SQL:-D
Performance
May 28, 2015 at 6:18 am
Here's the query to pull from the DMVs that Grant mentioned, but this will only get you what's going on right now.
SELECT er.session_id spid, er.blocking_session_id blocking_spid, st.text
FROM...
May 28, 2015 at 6:15 am
SteveEClarke (5/28/2015)
We have a stock code table with a description field and a brand field - when the data was entered, some of...
May 28, 2015 at 5:47 am
tim_harkin (5/27/2015)
declare @LastName NVARCHAR(255), @PostCode NVARCHAR(255), @DOB DATE, @Country NVARCHAR(255)SELECT COUNT(1)
FROM dbo.Persons
WHERE LastName = @LastName
AND PostalCode = @PostCode
AND DOB = @DOB
AND Country = @Country
AND PersonID<>0
This might just be a typo...
May 28, 2015 at 5:41 am
ramyours2003 (5/28/2015)
In sql 2012 i want to track the blocking details at a specific time is any query to get the data ?
If the specific time is now, then...
May 28, 2015 at 5:35 am
If you look at the OP and type the solution on a semi-normal keyboard while not trying to screw it up, then Gail's advice works fine: Use REPLACE.
May 28, 2015 at 5:33 am
Hugo Kornelis (5/28/2015)
May 28, 2015 at 5:29 am
GilaMonster (5/27/2015)
SQLRNNR (5/27/2015)
GilaMonster (5/27/2015)
Looks like I hit a few nerves with Sunday's editorial....Two words...
Ugh
Troll
I'd reply and point out the flaw in his logic (he's got scientific method and scientific consensus...
May 27, 2015 at 12:54 pm
Gail, getting back to your editorial for a moment...my compliments. Things like million-row test tables, letting the code do the talking and accepting results that differ from what we'd...
May 27, 2015 at 12:53 pm
SQLRNNR (5/27/2015)
Lynn Pettis (5/27/2015)
meilenb (5/27/2015)
Alan.B (5/27/2015)
Lynn Pettis (5/27/2015)
meilenb (5/27/2015)
Alan.B (5/27/2015)
meilenb (5/24/2015)
...Everyone knows that CO2, CH4 and N2O ...
How is the science clear on climate change when the scientists can't...
May 27, 2015 at 12:47 pm
Luis Cazares (5/27/2015)
Ed Wagner (5/27/2015)
Alan.B (5/27/2015)
Brandie Tarvin (5/27/2015)
And I was wondering how y'all felt...
May 27, 2015 at 11:52 am
Viewing 15 posts - 5,956 through 5,970 (of 9,399 total)