I feel the database server should be left to do the core task of processing SQL and serving data to clients. Other activities wherever possible should be moved off to...

I have the Web Platform Installer installed. I guess it installs Windows Installer 4.5 as a pre-requisite.

Unfortunately, that is not an option in our case. We are aware that extended stored procs are a deprecated feature. Yet due to certain constraints this is the course of...

Hello! I have received a reply on this on the MSDN forums. Interested folks can see it here: http://social.msdn.microsoft.com/Forums/en-US/netservices/thread/a701d145-3877-4c5b-8659-5618d5d8489f

Thanks!

Thanks a lot for your reply.. This is exactly what I was looking for!

Thanks to you for your insight. The requirement is to process data in a 300 million record table. This is a daily process and one of several such processes. Based...

Mumbai, India

In-memory databases are suitable for a specific set of applications which need extreme performance without worrying too much about recoverability. In such apps recoverability is handled outside the database by...

Hi Fredrik,

You can set up log shipping. But you may need your DBAs to get involved. If thats not a feasible option, you can check my article which kind of...

From the posted query it looks like the dynamic query may not be required. However if it is unavoidable to use a dynamic sql query, you can:

1. Declare a table...

Hi Razi,

You can find it in Visual Studio->New Project-> Visual Basic (or Visual C#)-> Database->SQL Server Project

Girish

Use the below line instead of the erroneous line:

set @cmd = @cmd + 'select @t1= replace(replace(replace(convert(char,getdate(),120),'':'',''''),'' '',''''),''-'','''')' + CHAR(10) /*here is syntax error near ':'*/

Basically since you are constructing T-SQL...

Get the XML into a string variable on the VB.NET side and then use:

Dim objDS As DataSet

Dim objXMLReader As StringReader

Dim strXML As...

Thanks for this tip. You have explained it really well in an easy to understand manner.

Girish

Thomas (4/14/2009)

---

This type of discussion reminds me of heated arguments I have had with Mr Celko about SQL standards......

A simple example of where set based operations break down is in...