Viewing 15 posts - 6,061 through 6,075 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 3, 2015 at 3:57 pm
.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 3, 2015 at 3:54 pm
MadAdmin (5/3/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 2, 2015 at 11:01 am
https://www.sqlskills.com/blogs/jonathan/how-much-memory-does-my-sql-server-actually-need/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 1, 2015 at 3:47 pm
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2015 at 1:49 pm
Viewing 15 posts - 6,061 through 6,075 (of 49,552 total)