amrinea (11/3/2011)

---

Our tempdb is stealing memory on the server and at various times of the day takes up more memory than any other database. I'd like to know what is...

for the record, MS says (http://msdn.microsoft.com/en-us/library/ms188609.aspx):

To be usable as a data file for bulk import, a CSV file must comply with the following restrictions:

Data fields never contain the...

I dont know that you can say "ignore field terminators if they are between quotes" as part of the bulk insert. The way I typically approach this is by...

Yes. If it has admin rights, then it is trying to access a databse which no longer exists. Look at the default trace for the process id of...

Grubb (11/3/2011)

---

Has anyone seen something like this before?

I'm creating a replication infrastructure almost identical to our successful 2005 implementation, using scripts generated from the '05 imp. Topology: One master,...

Matthew Nguyen (11/3/2011)

---

I used to have SSRS installed on this SQL box and I already removed SSRS by going to "program and features" (proper way to uninstall SSRS). ...

according to http://msdn.microsoft.com/en-us/library/ms152471.aspx "Connections are used by the triggers that fire at the Subscriber and propagate changes...

home work?

I wrote a procedure very much like what you describe here. I'm not sure what your constraints are, but the way I did it was with a...

Elliott Whitlow (10/31/2011)

---

I see two things wrong with this approach.

1. You use xp_cmdshell, which we have been having quite a raging discussion on in another thread.

2. It implies that you...

This is another excellent resource: http://msdn.microsoft.com/en-in/library/dd672789.aspx

I really encourage you to read both resources to get a firm understanding of tuning process.

That said, based on the little information...

Sapen (11/1/2011)

---

Hi All,

I was able to gather the wait_types base don the waitime, % and running %. I see big numbers here in my output. How should I approach to...

Lavanyasri (10/27/2011)

---

HI NJ,

Can you please look into the below for complete error ..

com.microsoft.sqlserver.jdbc.SQLServerException: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 11...

Lavanyasri (10/26/2011)

---

HI Team ,

I am finding the below error from application error log ??

any idea on this ??

com.microsoft.sqlserver.jdbc.SQLServerException: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol...

It's a complex and often debated topic. This is a pretty good discussion of the issue imo: http://sqlserverperformance.wordpress.com/2011/02/14/sql-server-and-the-lock-pages-in-memory-right-in-windows-server/

We need more information to determine what happened. Based on the information you have given, my suspicion would be that there was nothing wrong with the functions to begin...