Viewing 15 posts - 6,571 through 6,585 (of 49,571 total)
somubhandaru23 (2/11/2015)
February 11, 2015 at 9:55 am
Table definitions, index definitions and execution plan please.
February 11, 2015 at 9:12 am
Sioban Krzywicki (2/11/2015)
All they had to do was change LEFT OUTER LOOP JOIN to LEFT JOIN,...
February 11, 2015 at 8:37 am
Rather hot here, was 34 C around midday, scheduled blackouts in suburb containing office means no aircon.
Need: Ice-cold shower.
February 11, 2015 at 8:29 am
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 is...
February 11, 2015 at 8:21 am
below86 (2/11/2015)
February 11, 2015 at 8:20 am
You can't run a non-copy_only backup on anything other than the primary replica. Only copy_only backups (and log backups) can be run on the preferred replica.
February 11, 2015 at 7:35 am
below86 (2/11/2015)
GilaMonster (2/11/2015)
below86 (2/10/2015)
I know when listing the fields in your joins in the same way the index is created has always made a difference
It does not. Nor does the...
February 11, 2015 at 7:34 am
While it's possible to export data (look up BCP), SQL Server doesn't script databases as a backup.
SQL's backups are more efficient than scripts of the DB would be. Could you...
February 11, 2015 at 5:46 am
No, it won't.
BoL is talking about as part of a patch, the patch installation process can just replace the resource DB with an updated one instead of having to run...
February 11, 2015 at 5:16 am
Joy Smith San (2/9/2015)
Yes, I am clear on that part. I am planning to give them rights to find and kill their queries
You do realise that to do so...
February 11, 2015 at 12:50 am
I've seen systems like that. They're usually a mess because *someone* has been fiddling with things that they probably don't understand.
I've never changed either, when I do find them changed...
February 11, 2015 at 12:48 am
below86 (2/10/2015)
I know when listing the fields in your joins in the same way the index is created has always made a difference
It does not. Nor does the order of...
February 11, 2015 at 12:46 am
1 backup per file, with the datetime as part of the file name, and don't use backup devices.
February 11, 2015 at 12:40 am
Brandie Tarvin (2/10/2015)
So, Boston Threadzians... Wanna Fedex some snow down to Florida for me?
I could use some too. Enough to fill a swimming pool. It's seriously hot here at the...
February 10, 2015 at 5:38 am
Viewing 15 posts - 6,571 through 6,585 (of 49,571 total)