Viewing 15 posts - 44,461 through 44,475 (of 49,552 total)
How big are the tables in question? How many pages? (you can see that from the full output of index physical stats)
My guess is that the tables are very small...
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
September 16, 2008 at 11:04 am
Can you post the code please? There are places where you would have to explicitly cast as varchar/nvarchar(max) or be cut off at 4000/8000 characters. Considering the length is...
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
September 16, 2008 at 11:01 am
bcronce (9/16/2008)
I though SQL stops executing an AND statement once 1 comparison returns false.
Depends on the plan the optimiser comes up with. Sometimes it does, sometimes it doesn't. The order...
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
September 16, 2008 at 10:56 am
kevriley (9/16/2008)
GilaMonster (9/16/2008)
It doesn't take into account existing indexesGail, can you explain what you mean ??
Kev
If there's an existing index on a table on (for example) columns A, B, C...
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
September 16, 2008 at 10:48 am
Can you check the connection string that the app uses, see if it specifies an initial database. Also check what the default database is for sa.
A properly set up account...
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
September 16, 2008 at 5:39 am
Can you please post the table definitions, the index definitions and the execution plan?
To get the exec plan on SQL 2000, run the query with SHOWPLAN_ALL on, run to grid,...
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
September 16, 2008 at 5:37 am
Perry Whittle (9/16/2008)
sunshine (9/15/2008)
the previous statement must be terminated with a semicolon.this message is fairly descriptive!! The USE statement and exec must be separated by a semi colon like so
That...
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
September 16, 2008 at 5:32 am
Brandie Tarvin (9/16/2008)
WHOO HOO! I've had 2 sessions accepted!
Congrats. Is this your first time speaking?
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
September 16, 2008 at 5:17 am
State 16 means that the default DB or the DB requested by the login is not available. Check what DB the app in question wants and make sure that it'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
September 16, 2008 at 4:30 am
Do you know why the transaction log is growing? If you have regular log backups, it should not be continually growing.
Query the sys.databases view and see what the log_reuse_wait_desc column...
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
September 16, 2008 at 3:35 am
Unless you had one of the traceflags on or a profiler trace running with the deadlock events, there's no way to tell now what happened.
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
September 16, 2008 at 3:07 am
What's filling up the drive? The log files themselves (.ldf) or the log backups?
What else is on the drive?
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
September 16, 2008 at 3:00 am
The missing indexes DMVs are reset when the server starts. They can't be modified by a user.
One thing I would like to add is that the missing indexes DMVs should...
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
September 16, 2008 at 3:00 am
Enable traceflag 1222 (DBCC TRACEON (1222.-1))
With that on, a deadlock graph is written to the error log when a deadlock occurs. You can read through the graph to see what...
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
September 16, 2008 at 2:56 am
Because none of the strings you have there are reaching the 30/40 character limit for the varchar. The ISNULL returns for the first query a data type of VARCHAR(30) 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
September 16, 2008 at 2:55 am
Viewing 15 posts - 44,461 through 44,475 (of 49,552 total)