Viewing 15 posts - 43,891 through 43,905 (of 49,552 total)
Do you have any filters on the trace? Are you sure that the app's pointing at this 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 11, 2008 at 7:46 am
saby (10/11/2008)
This might happen due to conflicts happens some time mainly in this subcription database ... due to which it might showing transaction still pending while truncating 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 11, 2008 at 7:45 am
Jerry Hung (10/10/2008)
I don't have MSDN, debating on what to do for my home serverWindows 2008 Trial and SQL Server 2008 Trial? hee hee
Dunno about the OS (Windows home...
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 11, 2008 at 7:39 am
What do you want help with? I'm not sure I understand what's wrong.
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 10, 2008 at 8:00 am
There's no tool I know of that does that. I had an idea to write something like that a year or so ago, but it never got started.
The schema 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 10, 2008 at 7:46 am
Brandie Tarvin (10/10/2008)
I've actually stumped people with simple backup & restore questions of all things. You'd think *that* particular subject matter would be basic to everyone's DBA knowledge.
Oh, please... 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
October 10, 2008 at 7:04 am
saby (10/10/2008)
gail ..its a subcription database ..... and a live database
we are using sqlexpress edition for subcription database
Yes, I know. You said so before.
The above commands will create...
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 10, 2008 at 7:01 am
They have uses. The main one for me is error/progress logging in procs. If all that you're doing to a table var is inserting and then selecting the entire 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
October 10, 2008 at 6:56 am
Grant Fritchey (10/8/2008)
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 10, 2008 at 2:51 am
Michael Earl (10/8/2008)
While it is running, look for tables in tempdb:SELECT * FROM TempDB..Sysobjects WHERE Type = 'u'
Temp tables and table variables are added to the TempDB system tables when...
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 10, 2008 at 2:46 am
Statistics are only kept on the first column in any non clustered index i.e. SQL Server will use the first field to determine whether an index should be used.
Yes 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
October 10, 2008 at 2:41 am
That DB definitely has traces of transactional replication from somewhere in the past.
Ok. Try this.
Create a publication (transactional replication) in that database. Doesn't matter what's included. Pick any table.
Once it's...
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 10, 2008 at 2:27 am
They should be the same.
The cluster admin adds almost no overhead to SQL. It's IsAlive checks are very low-impact.
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 10, 2008 at 2:19 am
george sibbald (10/9/2008)
there is a column 'rowmodctr' in sysindexes which tracks the no of updates since the last update stats. Pretty sure this is what SQL uses for auto_update.
It's what...
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 10, 2008 at 2:11 am
No idea about the switch.
Why are you looking to load balance SQL Server? App servers or web servers load balance well and easily. It's not something that's generally done with...
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 10, 2008 at 2:08 am
Viewing 15 posts - 43,891 through 43,905 (of 49,552 total)