Viewing 15 posts - 18,151 through 18,165 (of 49,552 total)
Take a read through these.
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
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
June 11, 2012 at 6:40 am
Is there a witness server?
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
June 11, 2012 at 5:20 am
http://www.sqlskills.com/blogs/jonathan/post/How-much-memory-does-my-SQL-Server-actually-need.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
June 11, 2012 at 4:33 am
Your join is the wrong way around. Left join means all row from LEFT table, but the table that you want all rows from is on the right.
FROM #A1
LEFT...
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
June 11, 2012 at 4:31 am
Jai-SQL DBA (6/10/2012)
I still need to know the Steps \Queries how to recover the Files from Point 2.
Really? What was unclear about what I said?
GilaMonster (6/10/2012)
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
June 10, 2012 at 12:15 pm
Yes, clustered index columns should be as narrow as possible, 9 bytes is not wide. Even with a nice tool to do the work, you still have the time it...
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
June 10, 2012 at 11:52 am
The first thing to check would be to see if someone's fiddled with the max worker threads setting. It generally should be left at default unless there is very, very,...
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
June 10, 2012 at 11:30 am
You should probably speak to your system admin. There's no way we're going to know what the right settings are for an app on your network.
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
June 10, 2012 at 11:09 am
Top 1 without order by? So you just want any random row from the table? Doesn't really make much sense....
Please post table definitions, sample data and desired output. Read this...
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
June 10, 2012 at 11:07 am
Perry Whittle (6/10/2012)
are all talking scenario here or the actual configuration of your database?
I suspect the latest question is just a theoretical config for an broad question.
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
June 10, 2012 at 10:05 am
Start by reading these:
http://msdn.microsoft.com/en-US/library/cc917714.aspx
http://www.microsoft.com/technet/prodtechnol/sql/2005/scaleout.mspx
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
June 10, 2012 at 5:46 am
Please note: 4 year old thread
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
June 10, 2012 at 5:44 am
Table password history:
UserID
Password : varbinary (you are hashing passwords of course)
PasswordStartDate
PasswordEndDate
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
June 10, 2012 at 5:44 am
Jai-SQL DBA (6/10/2012)
Point2.In case anything goes wrong with my secondary Filegroup....can you help What would be the Steps to Recover files..In Case We can
Restore from backup if you need 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
June 10, 2012 at 5:08 am
Bouke Bruinsma (6/10/2012)
By the way I thought that since numeric is not native the CPU has to convert it before knowing how to deal with it.
Heh????
If you're talking about 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
June 10, 2012 at 5:05 am
Viewing 15 posts - 18,151 through 18,165 (of 49,552 total)