Viewing 15 posts - 6,931 through 6,945 (of 49,552 total)
Read committed snapshot is the read committed isolation level, implemented with row versions. It's not a separate isolation level like Snapshot is.
Hence you see Read Committed as 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
December 29, 2014 at 3:02 am
Have a read through this: https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/
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
December 29, 2014 at 2:42 am
Ok, so once you've taken the steps given in the message, try again.
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
December 29, 2014 at 2:38 am
Why are you suggesting restoring the database multiple times with the data and log files in different places each time? That's going to have the same effect as if you...
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
December 29, 2014 at 2:33 am
Why would they be 'much quicker' than temp tables? The reduced logging isn't going to come into play until there's a lot of data, same with the not needing to...
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
December 29, 2014 at 2:28 am
Maybe start by having a chat with your IT Security people and IT management around what policies you have around data access and related areas.
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
December 29, 2014 at 2:21 am
I still don't understand why you're putting brackets around DISTINCT as if it was a function. All that's going to do is confuse people who read the code.
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
December 29, 2014 at 2:09 am
Agreed, table variables can be terrible for performance. In fact, that's the main reason why multi-statement table-valued functions are often so bad (the last bullet point), because they use table...
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
December 29, 2014 at 2:08 am
gentong.bocor (12/29/2014)
Microsoft SQL Server Management Studio10.50.1600.1Microsoft Analysis Services Client Tools10.50.1600.1
Yup, that's RTM. You need to apply SP3 at least, preferably SP4 to this machine.
But SELECT @@VERSION, did u see the...
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
December 29, 2014 at 2:03 am
To start, turn traceflag 1204 off and use the 'newer' one that was introduced in SQL 2005 and which produces better deadlock graphs with more details. 1204 often doesn't produce...
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
December 29, 2014 at 2:01 am
Unfortunately, if you are splitting the partition and existing data belongs in the new partition, you're just going to have to accept that it will take time and you'll 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
December 29, 2014 at 1:59 am
Shafat Husain (12/29/2014)
Dear Immaduddin,Use the Below mentioned query
Select Distinct(LEFT(Code,3)) as CODE,COUNT(Name) as Name
From [TABLENAME]
Group by LEFT(Code,3)
Why the distinct when you have a group by, and why are you wrapping...
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
December 29, 2014 at 1:56 am
gentong.bocor (12/28/2014)
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
December 29, 2014 at 1:54 am
You use SPLIT to create new partitions. If it's taking time, it implies that there's data in the table that has to be moved to the new partition. This is...
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
December 29, 2014 at 1:47 am
To seek, you need a predicate, something to seek for. A seek is defined as a navigation down the index tree to find a value. You do not have anything...
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
December 28, 2014 at 12:07 pm
Viewing 15 posts - 6,931 through 6,945 (of 49,552 total)