Viewing 15 posts - 26,191 through 26,205 (of 49,552 total)
Sure. Have a read up on login triggers (assuming you're at least on SP2) and the Application_Name() function. Be careful, a mistake in a login trigger can lock everyone out...
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
May 11, 2011 at 6:15 am
Syed Jahanzaib Bin hassan (5/11/2011)
Apply first the Service Pack 2 if this is not R2 and apply CU 7 if this is R2,this problem has resolved in these updates
What problem?
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
May 11, 2011 at 6:07 am
Permissions to public are a security worst practice.
It's not just excel. If the permissions are that bad you could connect from Access, Word (most likely), any querying tool 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
May 11, 2011 at 5:47 am
If you want a database file size to reduce, you need to run a shrink operation. This is generally not recommended, so don't do it on the production server, just...
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
May 11, 2011 at 5:41 am
Basically it looks like SQL is not under any form of memory pressure and for the moment doesn't need more memory than it has.
The max server memory is 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
May 11, 2011 at 4:48 am
Thanks, I'll take a look later.
There's something wrong with the cardinality estimation, on SP4 the estimated rows are in the hundreds of thousands, while actual rows is 1. This mis-estimate...
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
May 11, 2011 at 4:34 am
Edit: Actually I don't want to know...
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
May 11, 2011 at 4:10 am
Edward-445599 (5/11/2011)
--table statsIX_TableA_idMay 11 2011 12:29AM314984882425471930.801755111.44844YES
The entire statistics output please. Dump it into a spreadsheet and attach it if it's too large.
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
May 11, 2011 at 3:59 am
Please don't post multiple threads for the same problem.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1106673-8-1.aspx
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
May 11, 2011 at 3:48 am
Possibly that it doesn't need more at present. The target memory is the amount SQL thinks it wants at the moment, so if it has that, it has what it...
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
May 11, 2011 at 2:44 am
Also maybe the output of DBCC SHOW_STATISTICS (TableA, IX_TableA_id) on both? Shouldn't be a problem with sensitive data, it's just the ID values.
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
May 11, 2011 at 2:41 am
Not the data. The definition - Create table, create index
May help to try and understand what the optimiser is thinking. It thinks that the useful index is missing, hard to...
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
May 11, 2011 at 2:35 am
Please, please, please don't just create any index in the missing index DMV. It's a suggestion, not a command. There are often near-duplicate indexes, massively wide indexes, etc.
It's a great...
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
May 11, 2011 at 2:24 am
What do you mean by 'database partition'? It's not a feature on its own, it usually refers to some mechanism of partitioning a table
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
May 11, 2011 at 2:06 am
Why are you using a while loop? Surely a set-based update will be faster?
You can query the locks help (sys.dm_tran_locks) though it will take some work to get that back...
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
May 11, 2011 at 2:04 am
Viewing 15 posts - 26,191 through 26,205 (of 49,552 total)