Viewing 15 posts - 42,526 through 42,540 (of 49,552 total)
madhu.arda (12/5/2008)
Dead lock occured again. I have couple of questions:1.In this dead lock, SPID 90 is automatically killed by SQL Server right?
Spid 90 wasn't even involved. The deadlock...
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
December 6, 2008 at 1:12 am
GSquared (12/5/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
December 6, 2008 at 1:05 am
Tables, indexes and execution plan please.
For the exec plan, right click on the plan (in management studio) select save as. Save it as a .sqlplan file. Zip that file 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
December 6, 2008 at 1:03 am
Don't change the where clause. You don't want to change what rows the query's returning (affected by the where clause), you want to change how the results are displayed (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
December 5, 2008 at 1:37 pm
Depends on the table, depends on the query, depends on the index.
e.g if the table has say 100 rows will it still use table scans despite there being indexes present...
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
December 5, 2008 at 1:36 pm
I'm going to guess that the columns are varchar and there's an index on at least one of them. If you compare a varchar column to an nvarchar parameter, SQL...
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
December 5, 2008 at 1:33 pm
I'm not even sure you can.
Maybe for a static reporting environment where all databases are static, but that's an odd case. SQL just doesn't scale 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
December 5, 2008 at 12:56 pm
Yes, but it's not the same databases.
Active/active is two instances of SQL each with their own databases, one running on each node (hence each node is active) and set...
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
December 5, 2008 at 12:32 pm
juancabrer (12/5/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
December 5, 2008 at 12:16 pm
There's no way to have two active instances of SQL on two machines using the same database files (as you would have in a load balancing scenario). The way clustering...
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
December 5, 2008 at 12:13 pm
Barkingdog (12/5/2008)
What is your opinion of this layout? OK, overkill, not enough?
Where are you going to put your backups?
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
December 5, 2008 at 11:36 am
Michael Earl (12/5/2008)
Anyone catch the question before it was edited?http://www.sqlservercentral.com/Forums/Topic614696-146-1.aspx
Go Steve for calling someone's question silly...
Since Steve's post was after the edit, I imagine he's referring to the question as...
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
December 5, 2008 at 11:01 am
Garadin (12/5/2008)
Shouldn't this one hit the same issue?
It should. No idea offhand why it isn't.
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
December 5, 2008 at 10:55 am
Schadenfreude-Mei (12/5/2008)
I have always been told that I cant have Simple for replication,
Whoever told you that is mistaken
if this is not so I would love 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
December 5, 2008 at 10:54 am
Does this work?
select top 1 id
from tblname
where tblname.person = 'xxx-xxx...'
group by id order by max(dttm) desc
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
December 5, 2008 at 10:45 am
Viewing 15 posts - 42,526 through 42,540 (of 49,552 total)