The correct answer is 1 INNER JOIN is used. When the database engine executes the SELECT query to return all rows that have an email address of 'jdoe@email.com' the following...

Hello All,

After few days struggle, I have sorted out all the issues I had been facing in the SQL Server 2008 Cluster install on Windows 2008 R2 server.

First point/Prob -...

Lost my points too because of the READ_ONLY option.

But I found experiments on MODEL regarding the collation - http://sqlmusings.wordpress.com/2008/10/11/fixing-collation-the-experiments/

I belive WMI query in SQL Server Alerts only works along with SQL Server EVENT NOTIFICATIONS. So if SQL Server EVENT NOTIFICATION doesnt contain the EVENT for memory usage (RAM...

I use the below WMI query to find the balance memory available in a server.

strComputer = "."

Set objWMIService = GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")

Set colSettings = objWMIService.ExecQuery ("Select * from...

Many thanks for that guys..

Please ignore this post. Misunderstood.

---------------------------------------------

In fact, NEWID() is also not throwing error while doing the multiple inserts of the same record

CREATE TABLE TestTable8(

col1 int,

col2 UNIQUEIDENTIFIER DEFAULT NEWID())

INSERT INTO TestTable8...

So, does this mean NEWSEQUENTIALID() cannot be used in tables undertaking in merge replication?

If so, we have to enforce the unique constraint explicitly for the proper working of merge...

I wanted to set...

If hard coded UNION statement is used, then whats the need for the @param1 variable here.

Are you a local admin in the server that you are doing the installation?

So does this mean WMI query is the only approach to get the information (alert) about the memory usage of the physical server where the SQL Server resides.

Hi all,

Is there a way to get an alert from SQL Server itself when a particular limit of Total available memory in the Server has been reached, not using...

Hi Nikhil,

You will have to do a bit reading about the FIXES in SQL Server 2005 SP3 CU1.

Certain fixes are performance enhancements, like below:

50003965956686 FIX: When you run a...

Hi all,

Its been a while but I tried this QoD today.

Even though the question is wrong and it returns error, the second statement (SELECT USER_NAME()) does provide a result.

The result...