Viewing 15 posts - 34,801 through 34,815 (of 49,552 total)
Look up Transparent Database Encryption (TDE). The whole point of TDE is that a backup cannot be restored to a server unless that server has the correct certificate. Same with...
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
January 12, 2010 at 4:22 am
Your clustered index has acct_id as the leading column and the query is filtering on acct_id. Hence there will be a clustered index seek. Why would you be expecting a...
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
January 12, 2010 at 4:19 am
What you're currently doing is the best way. Locking records while users type stuff in is a very bad idea. Leads to massive locking and very poor performance.
If a user...
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
January 12, 2010 at 4:13 am
That's never going to perform well. The conversion on the columns will force index scans or table scans.
I strongly recommend that you push for changing the data types to DateTime....
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
January 12, 2010 at 2:46 am
idiescreaming (1/12/2010)
What if they know exactly what each processes are doing?
Know and understand. That means seeing what the currently executing SQL is, what the currently executing stored proc 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
January 12, 2010 at 2:42 am
No replies to this thread please. Direct replies to the original question at http://www.sqlservercentral.com/Forums/Topic845923-146-1.aspx
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
January 12, 2010 at 2:28 am
Can you rather edit your previous thread and add the images saved as .png please? Or reply to your post inthe previous thread with the images
Having two threads each with...
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
January 12, 2010 at 2:28 am
My blog (see link below post), or the usergroup's website. http://www.sqlusergroup.co.za/
For some reason it doesn't display in firefox, I'm assured that it is being worked on. Jan meeting's not announced...
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
January 12, 2010 at 2:22 am
Transactions held open over multiple screens are usually a bad idea. What happens if the user gets to the comment screen then goes for lunch, leaving the rows locked, and...
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
January 12, 2010 at 1:37 am
chris.mckeever (1/11/2010)
I would never in a million years have thought to preface the index name with the table name, but that worked. Thanks!
The reason you need to is because...
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
January 12, 2010 at 1:32 am
John Rowan (1/11/2010)
Yep, you have to do the same thing when using DROP INDEX too.
However that is deprecated syntax. The newer syntax is
DROP INDEX <index name> ON <Table Name>
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
January 12, 2010 at 1:29 am
CirquedeSQLeil (1/11/2010)
Try this linkhttp://www.sqlpass.org/PASSChapters/AustraliaNewZealandandAfrica.aspx
There are only two PASS Chapters in Africa. The one I run in JHB and one up in Senegal (North West Africa)
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
January 12, 2010 at 1:25 am
Henrico Bekker (1/11/2010)
Except for Gail's workshops every now and then, are there any other and more regular events in South...
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
January 12, 2010 at 1:24 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic845875-150-1.aspx
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
January 12, 2010 at 1:22 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
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
January 12, 2010 at 1:21 am
Viewing 15 posts - 34,801 through 34,815 (of 49,552 total)