jsteinbeck (10/23/2008)

---

I've been using sp_executesql and found that if I try to pass in the table name it never works... I think it's comparable to early binding or somthing...

I...

This code comes from BOL. @IntVariable is a local variable. So what is different in my code?

DECLARE @IntVariable INT;

DECLARE @SQLString NVARCHAR(500);

DECLARE @ParmDefinition NVARCHAR(500);

/* Build the SQL string...

This is good news. I've been on SQL 2005 Performance course and they mentioned that Microsoft gets away from DBCC commands towards DMVs, and DBCC will eventually disappear. ...

Found it: suser_sname(sid)

Yes I did...

GilaMonster (8/26/2008)

---

Yeah, it's different in 2005 and 2008. That number's too large to be an object ID. It's actally a partitionID. To get the objectID back -

select object_id from...

Attached the file. Had to change the extension from .xdl to .txt.

I've actually posted it in the first message, but I did not realise that all the tags were...

PaulB (8/22/2008)

---

if the guy doesn't want to give your the download credentials just ask the guy to download it for you and put it in a share someplace in the...

Jason Crider (8/8/2008)

---

http://www.microsoft.com/sql/editions/64bit/SQL64bitAdvantages.mspx has a few more details as well.

It would appear that it would be a better idea to start moving towards 64bit on x64.

We are currently running...

Vivien Xing (8/7/2008)

---

SQL2000 has 64-bit. http://msdn.microsoft.com/en-us/library/bb469739.aspx

"This release of Microsoft® SQL Server™ 2000 (64-bit) includes the SQL Server 2000 (64-bit) Enterprise Edition. To run this release of SQL Server 2000 (64-bit),...

GilaMonster (7/15/2008)

---

Not possible in SQL 2000. SQL requires exclusive access to its data files

In SQL 2005, if all the databases are readonly (all of them) it's possible to do, though...

i6004835 (7/15/2008)

---

Your cache hit ratio is pretty low. It should be above 90% at most of the time (mine is around 99% all times with 3 GB memory only). Your...

MANU (7/15/2008)

---

I see there is table scan operator in execution plan. Investigate for which table its doing table scan and why. Is that table missing the required index or is...

I don't think this is supported. Even if you will be able to trick SQL Server into such configuration this is not acceptable for production environment. Besides, you...

I've tried running the SP using "with recompile" option and still got few instances of the execution taking longer than 8 seconds. 🙁