Viewing 15 posts - 19,996 through 20,010 (of 49,552 total)
There are many good uses for triggers and as many bad uses for triggers. The general rule for a trigger is to ensure it's as optimal as possible and does...
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 1, 2012 at 4:27 am
No, that's a custom role in all versions.
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 1, 2012 at 4:25 am
Then something else is causing the queries to run serially, or you have no queries that would block each other. Nothing to do with the lock modes whic, if both...
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 1, 2012 at 4:24 am
I'd start here:
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 1, 2012 at 2:58 am
Why do you want to eliminate IN? It's usually more efficient than an equivalent join.
If srno in IFDetails is nullable, you may want to use EXISTS instead. Also your first...
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 1, 2012 at 2:57 am
Usually yes. For corruption to fail a backup requires that the corruption is really bad or in a critical area, or that backups are taken WITH CHECKSUM.
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 1, 2012 at 2:54 am
There you go.
Hints override the default behaviour, so if SQL would by default have started with a table lock, specifying a page lock hint means that the locks start at...
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 1, 2012 at 2:52 am
1 - Leave it at 20 GB as it needs to be that size
2 - Change your indexing so that it doesn't need 20GB of log space (break up index...
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 1, 2012 at 2:50 am
Link works fine here.
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
February 29, 2012 at 2:48 pm
No. Once off means just that, one time. A one time, not to be repeated shrink after some unusual activity or problem has caused a file to be far larger...
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
February 29, 2012 at 2:40 pm
Nothing will trigger a checkDB. The only way a checkDB could be running is if it's been run by a user or run from a job.
You can kill a 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
February 29, 2012 at 11:08 am
Double check that the path in the system tables and the actual path is identical and that the SQL Server service account has full permissions to the folder.
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
February 29, 2012 at 11:01 am
L' Eomot Inversé (2/29/2012)
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
February 29, 2012 at 10:39 am
This isn't going to link child and parent calls, it's just about transactions. Only way it will help is if you start a tran in the outer procedure and then...
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
February 29, 2012 at 10:20 am
Same.
A once off shrink is ok, if something's happened to increase the file far beyond what's needed. Once off shrinks are ok, whether it's data or log. Scheduled shrinks...
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
February 29, 2012 at 10:20 am
Viewing 15 posts - 19,996 through 20,010 (of 49,552 total)