Viewing 15 posts - 29,701 through 29,715 (of 49,552 total)
ps. (10/27/2010)
Application team even said that they have applied *this* setting on a different server and a previous DBA helped them to do so!!
Then ask them what the setting is....
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
October 27, 2010 at 8:44 am
Please point out to the vendor that in general it's better to let SQL manage the locks itself. Even with a rowlock hint, SQL will still escalate the locks 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
October 27, 2010 at 8:37 am
Also asked here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=152157
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
October 27, 2010 at 8:17 am
Anyone got an idea how to track table changes. Server side traces, triggers, change tracking/change data capture not acceptable options.
http://www.sqlservercentral.com/Forums/Topic1011428-391-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
October 27, 2010 at 8:08 am
There's no simple query that will return this information. I've told you the possible ways, now you need to figure out which you can use, adapt and implement to get...
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
October 27, 2010 at 6:50 am
Server side trace, triggers. Maybe extended events, I'm not familiar with them. Also maybe worth a look into Change tracking/change data capture and SQL audit.
There's a fair few more options...
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
October 27, 2010 at 6:29 am
In SQL 2000 you'll need a server-side trace
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
October 27, 2010 at 5:53 am
Server side trace, maybe extended events, triggers will also work since you mean modification only. The info is not tracked automatically.
I seriously hope those are not the real names of...
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
October 27, 2010 at 5:48 am
It's not your account that needs access to that folder, it's whatever security context SSRS is running under.
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
October 27, 2010 at 5:10 am
Are you absolutely and completely sure that you will never have two rows inserted at exactly the same time?
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
October 27, 2010 at 4:45 am
Derrick Smith (10/22/2010)
If so, you should look into changing that column to nvarchar(max). It takes up roughly half the space of ntext, is faster, indexable
Why would it be half the...
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
October 27, 2010 at 4:21 am
Restore the full backup WITH Standby. That way the database is readable (but readonly) and you can restore additional logs.
This sounds like a reporting requirement, not a development environment. In...
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
October 27, 2010 at 4:12 am
You'll need a trace to get the DDL (schema) changes as SQL 2000 has no DDL triggers.
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
October 27, 2010 at 4:10 am
Already did.
GilaMonster (10/21/2010)
Same as any other databaseA little over 500 000 TB.
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
October 27, 2010 at 4:04 am
Declare the cursor over your table (which contains just the DBs that need shrinking). Then, for each database in there, use dynamic SQL that does a USE on the database...
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
October 27, 2010 at 2:30 am
Viewing 15 posts - 29,701 through 29,715 (of 49,552 total)