Viewing 15 posts - 14,266 through 14,280 (of 49,552 total)
Not enough information.
Decreasing fill factor is a decision you need to make based on how fast the index fragments and whether the increased size is worth the decreased fragmentation.
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 14, 2013 at 1:00 pm
Mark-545947 (2/14/2013)
How do I tell the trigger that there are more than one record being inserted?
There's no 'telling the trigger' anything. As far as SQL is concerned, a trigger works...
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 14, 2013 at 12:13 pm
Mark-545947 (2/14/2013)
Note, it's always the LAST item that gets recorded int BACK_ARCHIVE.WHY? I need all of them in BACK_ARCHIVE.
As I said earlier
That trigger assumes that any insert operation inserts one...
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 14, 2013 at 10:18 am
A scan of a portion (range) of an index. Anything more than a single row is considered a range
Low scans, high range scans, I'd say that index is well used.
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 14, 2013 at 10:13 am
But that's exactly what user scans are, the number of scans of the index caused by user queries.
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 14, 2013 at 10:00 am
homebrew01 (2/14/2013)
GilaMonster (2/14/2013)
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 14, 2013 at 9:48 am
What is the statement's wait type?
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 14, 2013 at 7:45 am
Bottom line, you can't put a * into a float column, it's not a float. It you want to badly mess thing up, you could convert the column to 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
February 14, 2013 at 6:02 am
The process that is waiting is trying to acquire that lock.
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 14, 2013 at 5:58 am
Can you be a bit more specific? All the names from where? Not in what table?
Table definition, sample data and expected results would help.
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 14, 2013 at 4:24 am
Vera-428803 (2/14/2013)
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 14, 2013 at 4:18 am
Ask the person what they meant, because your explanation does not have enough info. What users of what, what attributes, what back-end, what sessions?
The common meaning for 'database refresh' 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
February 14, 2013 at 3:42 am
Will only work if System is still a SQL login with 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
February 14, 2013 at 3:35 am
Go speak to your DBA and ask him for additional permissions on this server.
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 14, 2013 at 3:01 am
Check the error log, check the backup history tables, you have some 3rd party tool backing up your databases. Probably something one of your server admins put in place thinking...
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 14, 2013 at 2:58 am
Viewing 15 posts - 14,266 through 14,280 (of 49,552 total)