Viewing 15 posts - 45,571 through 45,585 (of 49,552 total)
You cannot modify the system tables in SQL 2005. Even in SQL 2000 where it was possible it was strongly recommended againast. It's a very quick way of messing 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
July 20, 2008 at 11:39 pm
bumoftheday (7/18/2008)
I know the hardware limitations are an issue but until I can get a request through approvals, appropriations, and budgeting... I have to work with what I got.... Sorry..
Do...
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
July 20, 2008 at 11:36 pm
I don't think you can, unless you have some profiler or a server-side trace running.
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
July 20, 2008 at 11:31 pm
Is there anything in the windows event log (under system) that gives any clue why the system was shut down?
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
July 20, 2008 at 11:26 pm
sbalaven (7/18/2008)
My question is, is there any query to find out the current status of the identity column. whether the identity_insert is on or off
No, because it's not 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
July 18, 2008 at 7:37 am
Lots of dynamic SQL. 😉 If you get stuck, we can help.
One other thing I noticed looking over your trigger code. Be careful of constructs like this in trigger code
SELECT...
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
July 18, 2008 at 7:32 am
angie stein (7/18/2008)
Thank you for the clarification! I will feel much more at ease now doing the shrinkfile.
Don't feel too easy with it. It's not something that should be...
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
July 18, 2008 at 7:26 am
Identity not for replication is not the same as Identity insert
sbalaven: identity insert is set per session and may only be enabled on one table at a time. So 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
July 18, 2008 at 7:23 am
Whatever query you called ran longer than 30 sec (or whatever the timeout is set to)
To fix, you are going to have to identify what query is been called 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
July 18, 2008 at 7:14 am
hengert (7/18/2008)
I am in no way a db expert, but I am required to create a generic trigger to track changes to a few tables. We don't want to write...
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
July 18, 2008 at 7:08 am
Query stats has no user-related info in. If you query that for the most recent statement, you'll get the most recent statement by any user on the server, not by...
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
July 18, 2008 at 7:04 am
Tanveer (7/17/2008)
Your solution will work only when I can predict a downtime.My query is for unplanned system crash. Hence I guess I need some other solution.
System crashes are by definition...
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
July 18, 2008 at 7:00 am
I'm not sure there is a way. You can get the currently executing statement from the sys.dm_exec_sql_text funtion, getting the sql_handle from sys.dm_exec_connections or sys.dm_exec_sessions, but that will just show...
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
July 18, 2008 at 6:51 am
Last time I saw that message it was because an online rebuild of the index wqas occurring at the same time. Check 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
July 18, 2008 at 6:48 am
As a first pass, that the query is using index seeks, not scans and there are no lookups.
I notice that all but one of the indx operations are full scans.
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
July 18, 2008 at 6:39 am
Viewing 15 posts - 45,571 through 45,585 (of 49,552 total)