Viewing 15 posts - 43,711 through 43,725 (of 49,552 total)
The maint plan that checks ingegrity runs checkDB. There's no need for a manual job if the maint plan's doing it
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
October 16, 2008 at 11:30 am
DBADave (10/16/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
October 16, 2008 at 11:29 am
The from clause
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
October 16, 2008 at 8:07 am
What you're considering isn't possible unless you have access to the source code of the SQL engine itself. There's no procedure that's called to insert rows into a table. Even...
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
October 16, 2008 at 8:06 am
Since you're reading all rows and all columns from the table (select * with no where clause), there is no way to get that particular query faster. It has...
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
October 16, 2008 at 8:02 am
This is a SQL Server site, not a MySQL site. You may have better luck at somewhere like dbforums
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
October 16, 2008 at 7:58 am
Reuse of a number has nothing to do with indexes. I'm guessing it's an identity column. Is that so?
Why do you want to be able to reuse numbers that have...
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
October 16, 2008 at 7:55 am
Well, if someone's shrunk your TempDB database down, it's certainly going to have an effect. Fix that and see if it makes a difference.
There's a lot of paralleling going 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
October 16, 2008 at 7:47 am
though, is there a ROWID function in Sql Server?
Not directly, no. The closest is the identity column and the ROW_NUMBER function, though neither is a direct replacement.
You can't easily get...
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
October 16, 2008 at 2:49 am
There's a chapter on it in "Inside SQL Server 2005: T-SQL Querying"
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
October 16, 2008 at 2:38 am
krayknot (10/16/2008)
BACKUP LOG WITH TRUNCATE_ONLY
Noting, of course, that Backup log will break the log chain. It will no be possible to restore to 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
October 16, 2008 at 1:55 am
At a very high level, parse, bind, optimise, process.
First the parser takes the SQL code, makes sure there are no syntax errors and then converts it into a tree-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
October 16, 2008 at 1:42 am
No, the if-else will not cause a recompile.
When SQL compiles the procedure the first time, it will compile and optimise all of the queries in the procedure. Even ones 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
October 16, 2008 at 1:40 am
There's a big, big difference between SQL's internal caches (which is what Kishore and I were talking about) and client-side caching
What front end language are you using?
You may get better...
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
October 16, 2008 at 1:30 am
oraculum (10/15/2008)
SOS_SCHEDULER_YIELD is the another prominent wait event that shows up...
What others show hight wait times?
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
October 16, 2008 at 1:27 am
Viewing 15 posts - 43,711 through 43,725 (of 49,552 total)