Viewing 15 posts - 31,546 through 31,560 (of 49,552 total)
Henrico Bekker (7/30/2010)
http://www.sqlservercentral.com/Forums/Search1-2-1.aspx?SessionID=qqepqxjqectt1q45bhztsfqb&SortBy=12&SortOrder=1
Returns:
Sorry your search results have expired within our database. Search results are held for around 30 minutes. You will need to perform your search again.
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
July 30, 2010 at 4:55 am
2005_DBA (7/30/2010)
What your experiance say ?
That you need more information before you start. Most important being:
Is it always slow, or it this unusual?
Is everything slow or just one query?
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
July 30, 2010 at 4:54 am
Queries causing locks is normal. They're supposed to take locks to ensure consistency and isolation.
To see what locks a connection has, query sys.dm_tran_locks.
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
July 30, 2010 at 4:52 am
Please post query, table definitions and index definitions, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
July 30, 2010 at 4:26 am
John Paul-702936 (7/29/2010)
IS THERE ANY WAY TO AVOID THIS INDEXSCAN , PLEASE
There is not. This is a non-SARGable predicate and cannot be used for a seek operation.
Think of 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
July 30, 2010 at 2:43 am
krishnaveni_chigurupati (7/29/2010)
SQL Server is terminating because of a system shutdown.
Someone shut the server down. This is not a SQL error, if the server is shut down SQL obviously has...
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
July 30, 2010 at 2:34 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic961120-338-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
July 30, 2010 at 2:32 am
Please don't post questions multiple times.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic961120-338-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
July 30, 2010 at 2:26 am
Detach the database (right click -> Tasks -> detach)
Go to explorer and move the files to where you want them to be
Reattach the database (right click the databases 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
July 30, 2010 at 2:13 am
Data corruption causes high-severity error messages and possibly inaccessible databases.
I assume all the indexes in question have lots of pages (say > 1000)?
Autoshrink enabled?
Manual shrink running?
Clustered index on a guid...
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
July 29, 2010 at 1:29 pm
sqlbuddy123 (7/29/2010)
Also MAXDOP is not recommended in OLTP systems.
You recommend leaving MAXDOP at 0 for OLTP?
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
July 29, 2010 at 1:27 pm
Is there a question here?
The error means exactly what it says. The login does not have permission to insert into that 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
July 29, 2010 at 1:26 pm
For what it's worth Paul...
I took your DemoDataPurity database, restored it and corrupted a single page so that I'd have a checksum error as well as the data purity 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
July 29, 2010 at 11:20 am
Why do you want to stop it? It's just an informational message.
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
July 29, 2010 at 10:46 am
AWE is a mechanism for 32-bit applications to access more than 2GB/4GB1 memory. It is not needed by a 64-bit application. SQL x64 will ignore the AWE setting.
(1) 2GB on...
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
July 29, 2010 at 10:22 am
Viewing 15 posts - 31,546 through 31,560 (of 49,552 total)