Viewing 15 posts - 9,871 through 9,885 (of 49,552 total)
Well, if you're having a problem with a database, stop shrinking it. Making problems worse is usually a bad idea. Shrink doesn't help matters, this isn't MS Access.
Shrink should never...
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 27, 2014 at 6:37 am
Well, 'when doing a shrink' should be a rare event in the first place.
I'm happy to have enough free space in the DB to accommodate 6 months of expected data...
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 27, 2014 at 6:25 am
You can, it'll clean up coding a bit, won't improve performance or change how the query runs.
WITH FilteredTable4 AS (
SELECT <whatever columns needed>
FROM table_4
...
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 27, 2014 at 6:20 am
Ok, so the query fragment i gave earlier is correct, it was just short a clause.
SELECT Booking_ID FROM dbo.BOOKING AS b
WHERE DG_FLG != 'Y' AND
NOT EXISTS (SELECT 1 FROM...
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 27, 2014 at 6:17 am
Without seeing the query, absolutely no idea.
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 27, 2014 at 6:00 am
You can't go straight from 2000 to 2012. You'll need to either migrate 2000 to 2005 and then 2005 to 2012 or 2000 to 2008/2008 R2 and then 2008 to...
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 27, 2014 at 5:33 am
pwalter83 (2/27/2014)
What I wish to achieve is no rows should be displayed where DG_FLG = 'Y' and OOG_FLG = 'Y'.
Which wasn't what you said in your initial post.
What I...
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 27, 2014 at 5:30 am
Without table definition and usable sample data I'm guessing, but...
WHERE NOT EXISTS (SELECT 1 FROM <Table Name> ib WHERE ib.Booking_ID = <outer table reference>.Booking_ID AND Flag = 'Y')
If you want...
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 27, 2014 at 4:46 am
Table definitions and index definitions as well please
Could you post the plan for just that query run in isolation, not that and every single other statement in what looks like...
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 27, 2014 at 2:44 am
VIII (2/27/2014)
when I try to generate script, nothing to get
when I try to export data, same message 'SQL Server detected 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
February 27, 2014 at 2:37 am
Grow the file or add additional files on another drive if it filled as part of regular activity.
On SQL 2000 it's very hard to identify queries using TempDB, the DMVs...
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 27, 2014 at 1:46 am
Sean Lange (2/26/2014)
GilaMonster (2/26/2014)
Blog and email working again. Finally.I hate DNS-related problems.
Woohoo!!! I was trying to reference something there earlier today and noticed it was still down.
Domain update finally went...
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 27, 2014 at 1:08 am
Steve Jones - SSC Editor (2/26/2014)
GilaMonster (2/26/2014)
Blog and email working again. Finally.I hate DNS-related problems.
Not GoDaddy, I hope. They lost my wife's DNS records and I had to play tech...
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 27, 2014 at 1:07 am
dan-572483 (2/25/2014)
I am trying to partition a pair of existing 200 million row tables to improve reporting performance.
Don't waste your time. Partitioning is not a performance tuning technique. While...
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 27, 2014 at 1:05 am
Google SQL Server statistics and do some reading. Far more than I can summarise here.
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 27, 2014 at 1:00 am
Viewing 15 posts - 9,871 through 9,885 (of 49,552 total)