Viewing 15 posts - 41,296 through 41,310 (of 49,552 total)
colin Leversuch-Roberts (1/30/2009)
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 30, 2009 at 11:45 am
I would suggest that you run a CheckDB at your earliest convenience, as more checks are done in 2008 then were in 2000 or earlier.
May the Force be with 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
January 30, 2009 at 3:01 am
baumgaertner (1/30/2009)
- Is there no workaround to have two batches in one if-condition?
Dynamic SQL, or Christopher's deferred naming trick
if (level = 1)
begin
alter table tblCustAttrDefValue add strHelpValue...
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 30, 2009 at 1:38 am
Bruce W Cassidy (1/29/2009)
sometimes it's fun having a good ol' mud-slinging match with someone who is absolutely sure they are right. And sometimes that's even me!
We can...
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 29, 2009 at 2:33 pm
In the future, if you do that, please edit the incorrect post to point to the new one, then anyone who reads it knows that it's not to be replied...
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 29, 2009 at 2:31 pm
Generally, I start with 1/2 or 1/4 the number of cores, and see if there's any contention on the allocation pages in Tempdb (which is the reason for splitting). If...
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 29, 2009 at 2:12 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic646379-149-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 29, 2009 at 2:02 pm
SG (1/29/2009)
That's what I started with before I tried the distinct, I tried it again but still got duplicates.
Can you strip the query down to just the essentials (that still...
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 29, 2009 at 1:59 pm
Temp tables are specific to the connection that created them, and they will be dropped when that connection closes. If you want a table that multiple users can use, rather...
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 29, 2009 at 1:45 pm
I'll check tomorrow, if someone hasn't got there first.
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 29, 2009 at 1:41 pm
Per database.
Again, only really useful if you have IO problems and the file are going on separate physical drives
Why are you thinking 1 file per cpu per filegroup? What was...
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 29, 2009 at 1:41 pm
Then try something like this:
select top 1000 * FROM
(SELECT lc.email
l.leadid,
...
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 29, 2009 at 1:38 pm
TS stands for Technical Specialist. The 'entry level' certification.
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 29, 2009 at 1:14 pm
SG (1/29/2009)
So I tried this but am still getting duplicates - why?
select top 1000 * from (
select
...
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 29, 2009 at 1:02 pm
Can you post the queries, the table schemas, the index definitions and the execution plans with that table as part of the query? (save as a .sqlplan file, zip 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 29, 2009 at 12:53 pm
Viewing 15 posts - 41,296 through 41,310 (of 49,552 total)