Viewing 15 posts - 14,491 through 14,505 (of 49,552 total)
http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx
2008 or 2012, up to you. If you work mostly with 2008, get the 2008 cert. If you work mostly with SQL 2012, get the 2012 cert
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
February 1, 2013 at 6:52 am
Since you'd only decrypt and fetch the columns when you need to decrypt then, no it doesn't make any sense to do that.
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
February 1, 2013 at 6:45 am
Page splits are caused by inserts into the middle of indexes and updates that grow the row, nothing else. They're internal to SQL.
As for thresholds, take them with a grain...
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
February 1, 2013 at 6:26 am
Table definition and easily usable data would be a great help, but this may be a start...
SELECT <stuff> FROM Policies p INNER JOIN PolicyDetails pd ON p.PolType = pd.PolType WHERE...
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
February 1, 2013 at 5:53 am
Table scan - read of the entire table
Table seek - no such thing
Index scan - read of the entire index
Index seek - search into an index for a specific value...
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
February 1, 2013 at 5:45 am
Sure, often a lot higher that what you have there.
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
February 1, 2013 at 5:33 am
Have a look in Books Online for the Unpivot keyword, that's what you're looking for here, probably followed by a Pivot.
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
February 1, 2013 at 5:32 am
Depends on the IO subsystem, memory, CPU, concurrent connections, etc.
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
February 1, 2013 at 5:24 am
Well, hopefully people will take my word for it...
We used to use , as the decimal marker, but that practice stopped many years ago (while I was still at school)....
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
February 1, 2013 at 3:50 am
Please ask new questions in a new thread. Thanks
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
February 1, 2013 at 3:45 am
Read less data (optimise queries), add memory, optimise the IO subsystem
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
February 1, 2013 at 3:36 am
Vertigo44 (2/1/2013)
Also, should I run DBCC INDEXDEFRAG after DBCC DBREINDEX completes?
Not unless you like doing your index maintenance twice.
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
February 1, 2013 at 1:45 am
PageIOLatch isn't a lock, it's a latch. Usually used when SQL is moving pages around from memory to disk or disk to memory. Probably you don't have enough cache memory...
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
February 1, 2013 at 1:44 am
Increase the frequency of your log backups.
Why on earth would you try to shrink a full log? Full means no free space left in the log, surely that would suggest...
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
February 1, 2013 at 1:42 am
I'd start by getting rid of the table variable. Any more advice than that will need the stuff Anthony asked for.
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
February 1, 2013 at 1:40 am
Viewing 15 posts - 14,491 through 14,505 (of 49,552 total)