Viewing 15 posts - 2,611 through 2,625 (of 6,676 total)
If you are looking for results from the insert - you could use the OUTPUT clause on the INSERT/UPDATE statement itself instead of using a trigger.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 16, 2017 at 4:05 pm
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 16, 2017 at 12:29 pm
You could use sys.dm_io_virtual_file_stats and capture the data every couple of seconds to a table. Then you can query that table for the IO stats specific to the database...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 8, 2017 at 9:11 am
The information does exist in the default trace - the schema change history report will show you the information you are looking for...to get the code open Profiler and have...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 7, 2017 at 9:36 am
donald.mcneill (1/6/2017)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 7, 2017 at 9:21 am
If the query works with a variable - then why would you be concerned about using the literal value? What is happening here is that SQL Server uses the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 3, 2017 at 12:08 pm
Jeff Moden (12/30/2016)
BOR15K (12/30/2016)
But I think we have drifted way beyond my original question of where to place WITH (NOLOCK).
With regards to your concern it might always select...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 30, 2016 at 2:21 pm
Mystic1287 (12/29/2016)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 29, 2016 at 11:16 am
You need to fix this issue:
CONVERT(datetime,PackageActivityDateTime, 120) < CONVERT(datetime,@PackageActivityDateTime, 120)
The column should already be a datetime data type so it should not need to be converted. And why...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 29, 2016 at 8:32 am
Snargables (12/28/2016)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 28, 2016 at 12:16 pm
Snargables (12/28/2016)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 28, 2016 at 11:53 am
In your version - you have '' as the default value which is not a valid date. An empty string as a date is implicitly converted to a 0...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 24, 2016 at 10:23 am
How did you determine that only 11GB of space is in use? I have seen this kind of issue with one or more tables where LOB data use to...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 16, 2016 at 12:44 pm
This does not look like a Microsoft Failover Cluster configuration.
The file system on those files make me suspect you are using some type of clustering file system that allows access...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 14, 2016 at 12:31 pm
You cannot have a local drive defined as a share in the cluster. You need to create a new drive - add that drive to the cluster - then...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 13, 2016 at 4:10 pm
Viewing 15 posts - 2,611 through 2,625 (of 6,676 total)