Viewing 15 posts - 3,271 through 3,285 (of 15,381 total)
BWFC (2/11/2015)
It's funny. When it snows in my area (usually get 1 snow/ice storm per year, of no more than 4 to 6 inches), we get all of the...
February 11, 2015 at 9:22 am
GilaMonster (2/11/2015)
Sean Lange (2/11/2015)
admin 31599 (2/11/2015)
--Current queriesSELECT
r.session_id,
s.TEXT,
r.[status],
r.blocking_session_id,
r.cpu_time,
r.total_elapsed_time
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s
Find blocking_session_id or heavy one and then
kill #
If using this script very often the next step...
February 11, 2015 at 8:24 am
Jeff Moden (2/11/2015)
Sean Lange (2/11/2015)
admin 31599 (2/11/2015)
--Current queriesSELECT
r.session_id,
s.TEXT,
r.[status],
r.blocking_session_id,
r.cpu_time,
r.total_elapsed_time
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s
Find blocking_session_id or heavy one and then
kill #
If using this script very often the next...
February 11, 2015 at 8:24 am
admin 31599 (2/11/2015)
--Current queriesSELECT
r.session_id,
s.TEXT,
r.[status],
r.blocking_session_id,
r.cpu_time,
r.total_elapsed_time
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s
Find blocking_session_id or heavy one and then
kill #
If using this script very often the next step is go to...
February 11, 2015 at 8:16 am
dajonx (2/10/2015)
That's what I thought (the checks occur before the trigger firing), but I couldn't find that info in writing anywhere. Unfortunately, the [ColumnB] is...
February 10, 2015 at 2:29 pm
Jeff Moden (2/10/2015)
Joy Smith San (2/9/2015)
I am planning to give them rights to find and kill their queries, if they cannot fine tune it.Really, [font="Arial Black"]REALLY [/font]bad idea.
Plus a...
February 10, 2015 at 1:10 pm
dajonx (2/10/2015)
I was wondering if there was a way to redirect an insert to another column...
Example:
Original Insert Statement:
INSERT INTO ([columnA], [columnB])
SELECT '2015-01-01 00:00:00', 99.99
We have changed [columnB] from...
February 10, 2015 at 1:09 pm
Steve Jones - SSC Editor (2/10/2015)
Supposed to be 50s the next week. Getting warmer in the mountains as well, which sucks. Supposed to ski this weekend.
You can have it back....
February 10, 2015 at 1:03 pm
Steve Jones - SSC Editor (2/10/2015)
Sunny and 45F in Denver 😀
Thanks for blowing that to the East. It warmed up quite nicely today to about the same thing. The temp...
February 10, 2015 at 12:31 pm
Jeff Moden (2/9/2015)
K2mission (2/9/2015)
The thought was to allow for as many 6-character combinations as possible. Using the alphabet along with numbers offered 2,176,782,336 combinations whereas numbers alone would only offer...
February 9, 2015 at 10:25 am
Andy DBA (2/9/2015)
venoym and Sean - Please re-read the only bold font sentence in my last post and...
February 9, 2015 at 10:19 am
venoym (2/9/2015)
Andy DBA (2/6/2015)
I apologize for not posting...
February 9, 2015 at 7:11 am
Here is Aaron's blog post about MERGE. http://www.mssqltips.com/sqlservertip/3074/use-caution-with-sql-servers-merge-statement/%5B/url%5D
February 6, 2015 at 2:48 pm
abendigeri (2/6/2015)
Yes i know the data is really bad...But this data is being extracted from some other multiple source and then it has to be...
February 6, 2015 at 2:38 pm
Your data is real disaster here to say the least. Not sure why your data is so sparse but whatever, it just adds another step in the process.
First we...
February 6, 2015 at 2:25 pm
Viewing 15 posts - 3,271 through 3,285 (of 15,381 total)