Viewing 15 posts - 6,061 through 6,075 (of 49,571 total)
TeraByteMe (5/3/2015)
I didn't say anything about viewing the definition of the object I said I can't see it anywhere.
The way SQL permissions work is that you cannot see an...
May 3, 2015 at 3:57 pm
MadAdmin (5/3/2015)
May 3, 2015 at 4:40 am
TomThomson (5/1/2015)
and some of the comments provoked by that article provide an absolutely amazing display of male chauvinistic sexism.
Doesn't come as any surprise at all.
May 2, 2015 at 11:20 am
With the SOLE exception of read committed snapshot, isolation levels are effective from the SET TRANSACTION ISOLATION LEVEL statement until the end of the batch or until the isolation level...
May 2, 2015 at 11:18 am
MadAdmin (5/1/2015)
Maybe put another way, if I did not do checkdb on tempdb, what could go wrong?
You could need to restart SQL at an inopportune time.
May 2, 2015 at 11:01 am
DicksonMulwa (4/30/2015)
Will the SQL Server engine recovery process roll forward or roll backwards transaction (T1)?
If the COMMIT TRANSACTION for T1 is recorded in the log it will be rolled forward....
May 1, 2015 at 3:46 pm
a_ud (5/1/2015)
-The DB model was in Full recovery mode, log_reuse_wait_desc: LOG_BACKUP (I take this means the TLOG has been backed up? and not that is waiting for it.
No,...
May 1, 2015 at 3:44 pm
ramana3327 (5/1/2015)
To use RCSI for individual querywe have to use
ALTER DATABASE AdventureWorks2014 SET READ_COMMITTED_SNAPSHOT ON
for each transaction if it is not enabled in the db level
No.
You can't use read...
May 1, 2015 at 3:43 pm
SimonH (4/30/2015)
I clearly need to find some time to re-write this procedure.
Not for the reason you posted.
Temp table caching is a feature, it's designed to reduce the overhead when creating...
May 1, 2015 at 3:39 pm
IN doesn't work that way. An IN takes each value in the list (in your case the variable @Region) and converts them to a series of OR statements.
Both of...
April 29, 2015 at 4:51 pm
Not, in general, a good idea. Procedures with multiple branching logic often suffer from performance problems, and besides it's against good software engineering practices (single responsibility principle)
April 29, 2015 at 4:46 pm
MAXDOP = number of threads concurrently *running*, not max number of threads. With maxdop of 8 you could see way more than 8 threads. No more than 8 will ever...
April 29, 2015 at 4:44 pm
Two problems.
Shrink Database should not be scheduled. Full stop.
The index rebuild in the maint plan is a brute force rebuild everything that often isn't required.
Recommend:
Remove the Shrink DB. Replace...
April 29, 2015 at 1:49 pm
Viewing 15 posts - 6,061 through 6,075 (of 49,571 total)