Viewing 15 posts - 46,066 through 46,080 (of 49,552 total)
Find what is making them run long and fix it.
Seriously now. First you need to identify why the query is running slow. Is there blocking? Are there excessively long waits?...
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 26, 2008 at 1:29 am
Excellent.
If you find there is data you can't recreate, post again here and I'll try and help you salvage as much as possible from the DB.
You may also want 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
June 26, 2008 at 1:03 am
Have you seen the case statement before?
select datepart(ww, created_date) as week, count(*) as count,
CASE created_as
WHEN 'true' THEN 'Some String 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
June 26, 2008 at 12:48 am
No.
The point of having a transaction log alone on a drive is so that the disk's write head is always (*) in position to write, since a log is written...
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 25, 2008 at 11:54 am
I'm not sure how to recover from that problem without loosing some data.
If you try to set the database into emergency mode, can you view the tables? Can 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
June 25, 2008 at 11:35 am
Glad to help.
Now plase make sure that all of your databases, including the system ones (master, model, msdb) get regularly backed up.
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 25, 2008 at 11:17 am
Leslieo (6/25/2008)
At any rate, I've found the Head First C# book to be worthwhile for training, though you'll need the C# doorstop reference to go with it.
I've used the Java...
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 25, 2008 at 11:06 am
2005.
SQL 2000 standard supported max 2 GB, regardless of the setting of the /3GB switch or AWE
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 25, 2008 at 7:58 am
The stuff I gave tyou is to see why the tran log can't be truncated. Once we know that, fixing is usually isn't hard.
Auto commit is the SQL default. 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
June 25, 2008 at 7:44 am
If it's a 2005 database rather don't enable torn page detection. Enable page checksum. It's a more accurate way of detecting damage to pages.
You want some form of page protection...
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 25, 2008 at 7:38 am
Ok, there are other ways of doing that then reading the tran log (which is messy)
Have a look at the sys.databases view. There's a column called log_reuse_wait_desc. It lists 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 25, 2008 at 7:28 am
subesh_bulbul (6/25/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
June 25, 2008 at 6:32 am
I wouldn't worry so much about the questions asked. I'd worry about the questions not been asked.
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 25, 2008 at 5:58 am
You really shouldn't be flushing the cache regularly.
What are the symptoms of the problem that you are seeing?
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 25, 2008 at 5:53 am
You don't need the distinct inside the IN. In is just checking for existance. It doesn't matter how many times a value is there.
Other than that, I don't think there's...
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 25, 2008 at 5:29 am
Viewing 15 posts - 46,066 through 46,080 (of 49,552 total)