Pablo Campanini-336244 (12/7/2012)

---

...Description: Failed to decrypt protected XML node "DTS:Password" with error 0x80070002 "The system cannot find the file specified.". You may not be authorized to access this information. This...

I've designed stored procedures with XML parameters before to allow the calling application to insert or update multiple records at the same time with just one stored proc call. ...

the easiest way to get all the information is the FILEPROPERTY function, such as:

SELECT DB_NAME() AS database_name, name AS file_name, physical_name,

size/128.0 AS size_meg,

...

Database mail doesn't have a very large impact on a SQL Server. It does use Service Broker so it's not zero impact, but it's still lightweight while having the...

I don't know how many instances you...

Try running this query to see how many rows and how big the table is, could this one table be too big for the client program to handle?

SELECT s.name AS...

there's a dynamic management view for that! sys.dm_exec_requests

http://msdn.microsoft.com/en-us/library/ms177648(v=sql.100).aspx

it has a column percent_complete that...

What you will need to balance are code reusability vs. performance. If you put too much functionality inside one stored proc, thent he query optimizer will have a more...

baabhu (12/7/2012)

---

...The only thing you've to consider is database file sizing is costly operation. Consider you apply on non peak hours. Restrict your file growth 8 GB or...

Abu Dina (12/6/2012)

---

...In other words, if the SQL instance I need to connect to is not in the domain where AD is used, I must configure it to use both...

Doing some of these subqueries up front and storing them in temp tables is definitely a place to start. You typically want to hit each table as few times...

SQL_ME_RICH (11/22/2012)

---

...Is there any good reason you can think of to always be using the WITH(NOLOCK) hint in all queries?...Wouldn't the WITH(NOLOCK) defeat the whole purpose of discouraging against dirty...

Esentially that machine would have to be turned on all the time, so clients could connect to it and maintenance such as database backups, etc, could be run. That...

I'm not sure what you mean by install on a TP (not a server)?

andy 56206 (12/5/2012)

---

..I am using the following code:

SELECT cc.ResidencyZip as ZIP, e.EthnicityDesc,

Count(e.EthnicityDesc) as 'Record Count',

...