Viewing 15 posts - 44,626 through 44,640 (of 49,552 total)
Probably because of the affect they have on queries. Bad cardinality = bad query plans = higher than expected IO and CPU.
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
September 9, 2008 at 1:44 am
Tomm Carr (9/8/2008)
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
September 9, 2008 at 1:35 am
So, if you obtained the question and answer sheets for an upcoming college/university exam and used those to prep for the exam, would that be cheating, or smart work?
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
September 9, 2008 at 1:30 am
An existing table, or a hypothetical 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
September 8, 2008 at 10:58 am
Please don't cross post. It jsut wastes people's time and fragments replies. Many of us read all the forums
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic565566-8-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
September 8, 2008 at 10:58 am
Check the windows event log, see if you have any drive errors. SQL doesn't corrupt its own files.
If the problem keeps reoccurring, I would suggest you move the DB...
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
September 8, 2008 at 10:53 am
SQL should run under a non-administrative account. It's a security best practice.
Create a domain account for SQL. I would suggest that you se the domain account so that it does...
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
September 8, 2008 at 9:11 am
GSquared (9/5/2008)
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
September 8, 2008 at 8:43 am
If there's no chance of overlap (which sound like there isn't in this case), that should be union all. Union means that SQL will do a distinct sort of 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
September 8, 2008 at 8:41 am
You can write your stored procedures so that they reference tables in both databases. Or, if the developers are beiong lazy and writing ad-hoc SQL code, they can use 3-part...
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
September 8, 2008 at 8:36 am
Because an order by is only valid in the outermost select statement. It can be used within other blocks, but then must be a part of a TOP n, 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
September 8, 2008 at 8:31 am
The only time you can use a snapshot like that is if you have database mirroring. Providing the mirror DB is synchronised (note, synchronised, not running in synchronous mode), then...
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
September 8, 2008 at 8:29 am
What's the purpose behind this? Redesigning a database that's in use is not something that I see done often. It can require a lot of time and money and, unless...
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
September 8, 2008 at 8:25 am
LaTeX - it's a document markup language that's used extensively in academic fields. Based on TeX
Timothy: Personally I'd just use a verbatim block, then you can format it any way...
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
September 8, 2008 at 8:22 am
You can take backups of the log of a database that's used for replication as long as the DB is in full recovery mode. No problems there
The log shipping requires...
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
September 8, 2008 at 8:16 am
Viewing 15 posts - 44,626 through 44,640 (of 49,552 total)