Viewing 15 posts - 16,066 through 16,080 (of 49,552 total)
briancampbellmcad (10/16/2012)
First, isn't the line "WHERE Transaction_Type = 'From Bulk Assignment'"
correctly referenceing the INSERTED...
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, 2012 at 1:53 pm
Ooh, need to go update my reading list....
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, 2012 at 1:16 pm
What, the database backup won't restore? (restore from backup as in RESTORE DATABASE <db name> 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
October 16, 2012 at 12:49 pm
No, it's not.
You can remove their access, but that will just slow them down if they really want access. Someone who is local admin on the server can get sysadmin...
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, 2012 at 12:44 pm
Restore from backup.
You've got a data file from a DB that was not shut down cleanly, so SQL cannot just recreate the log file. You can force it to 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
October 16, 2012 at 12:42 pm
Size of tables, throughput of IO subsystem.
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, 2012 at 12:40 pm
Inside a trigger you have access to the inserted and deleted pseudo-tables which contain the rows that were affected by the operation that fired the trigger. You need to change...
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, 2012 at 12:39 pm
Index rebuilds... very much an 'it depends'
Depends on the fragmentation %, the size of the table and how the table is accessed. Low fragmentation, small table or mostly seeks 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
October 16, 2012 at 12:28 pm
menon.satyen (10/16/2012)
Although one thing to note is that post index rebuilding, the transaction log grows. It needs to be shrunk.
No, it absolutely does not. Please read through this - Managing...
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, 2012 at 12:25 pm
I suspect this is a performance problem at the root, the 'hang' sounds like a query that's now running far too slow because of data volume, lack of maintenance ...
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, 2012 at 12:24 pm
Perry Whittle (10/16/2012)
What i would want the author to take away from this is to always fully research your article and if you're unsure then have someone peer review it
I'll...
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, 2012 at 12:13 pm
Scheduled maintenance jobs, most likely index rebuilds
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, 2012 at 11:12 am
Check SQL Server Configuration Manager. The screen shot of installed programs shows 2 SQL installations, one 2005, one 2008 R2.
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, 2012 at 11:09 am
Also since you have not specified a server, that will attempt to connect to the default instance on the machine you are running it on. If that's not the correct...
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, 2012 at 11:07 am
Marios Philippopoulos (10/16/2012)
Perry Whittle (10/16/2012)
Marios Philippopoulos (10/16/2012)
I will probably not do that, as it seems a bit too much voodoo to me... 🙂
Whats voodoo about creating a table, inserting...
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, 2012 at 10:54 am
Viewing 15 posts - 16,066 through 16,080 (of 49,552 total)