Viewing 15 posts - 47,176 through 47,190 (of 49,552 total)
Rather don't shrink your dataabses, especially straight after an index rebuild. Index rebuilds put the index pages in order, shrink will move them completely out of order. You may as...
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
March 15, 2008 at 7:20 am
Can you post the table structure and index defs please? Also, if possible, the execution plan (without the index hints in place) (run SET SHOWPLAN_ALL ON before the queries) in...
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
March 14, 2008 at 3:20 pm
Full and diff backups don't truncate the log. Log backups do.
If you have an full backup at midnight and hourly transaction log backups, the the log backups only contain...
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
March 14, 2008 at 3:18 pm
GSquared (3/13/2008)
In that case, you'd be recovering from the prior day's full backup, and the most recent log backup.
To do that, you'll need the previous day's full...
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
March 14, 2008 at 11:58 am
I believe it has to do with the order of the columns in the group by, not the select. I don't have a SQL instance around right now to test...
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
March 14, 2008 at 11:41 am
Make very sure that you have viable backups somewhere other than on the server itself. See here[/url] for why.
There no point in doing a diff straight after a full 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
March 14, 2008 at 11:41 am
jmanly (3/14/2008)
Uncommitted transactions are never written to the data files, are they?
They can be. Imagine an update that affects 2 GB of data on a server 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
March 14, 2008 at 11:30 am
Oh, and also. 20 million rows is not a trivial amount of data. Index seek or no index seek, it will take time to fetch that data from disk (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
March 14, 2008 at 11:18 am
Looking at just that scenario, and ignoring any possibility of other queries, I'd do the following.
Drop the NC index on Col1. As Grant said, it's not necessary. Make the PK...
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
March 14, 2008 at 11:15 am
Restart the SQL instance.
I asked the same question of PSS a couple years back. There's no command, documented or other to clear out memory in MemtoLeave
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
March 14, 2008 at 11:09 am
Is the server you're writing to running? Are the permissions of the account running profiler sufficient?
It's generally recommended to run server-side traces to file, not to table, and import 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
March 14, 2008 at 11:04 am
Any machine that has the SQL management tools on it (Management studio and the like) will have profiler. You can profile the server from any machine that can see it.
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
March 13, 2008 at 12:53 am
Bracket in the wrong place. This passes a syntax check.
CREATE TRIGGER trg_PreventInvalidHours ON Works_On AFTER UPDATE AS
IF EXISTS (SELECT 1 FROM inserted i inner join deleted d
on i.ESSN =...
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
March 13, 2008 at 12:52 am
David Lester (3/12/2008)
Ok, so when executed a view gains a cached execution plan, which is reused, similar to a stored proc.
Any query that you run, whether you select 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
March 13, 2008 at 12:41 am
Then SSN is what the join needs to be on.
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
March 12, 2008 at 4:10 am
Viewing 15 posts - 47,176 through 47,190 (of 49,552 total)