Isn't the "FETCH NEXT FROM cur_res" statement inside the WHILE loop in wrong place?

Check it out.

What about CLR and calling it from T-SQL?

Thanks for the reply!

In the beginning the CPU is planned to be less powerful until another machine is released, then it will be 24 cores with 128GB RAM.

Jobs do simple...

What is the recovery model of the database for which indexes are rebuilt?

Log space depends a lot on it, when in question is the recovery model.

See http://www.sqlservercentral.com/articles/Administration/64582/ and http://technet.microsoft.com/en-us/library/ms191244(v=sql.105).aspx

Additional info to add is that databases use Simple recovery model running on Failover cluster.

Hi Jared,

I came up to the same error message with an XE session, and could not find any information about this error.

Did you find an answer to this?

Vimal Lohani (10/15/2014)

---

HAHA,

Still wrong answer

admin has not tested it.

Answer should be two rows.

OrderIDProductNameProductQty

1 ...

You can add the following event to the session

ADD EVENT sqlserver.blocked_process_report(

ACTION(package0.process_id,sqlserver.client_app_name,sqlserver.client_hostname,sqlserver.database_id,sqlserver.database_name,sqlserver.plan_handle)

WHERE ([sqlserver].[database_name]=N'Db1' OR [sqlserver].[database_name]=N'Db2' OR [sqlserver].[database_name]=N'DB3')),

and then see if you have more details.

Open/import you document in Excel (comma delimited). Then go to the Data tab and there you have "Remove Duplicates" button. Click it and job is done.

Robert klimes (10/6/2014)

---

You could view it in the GUI. Go to management->extended events->session->Deadlock. right-click on package0.event_file and choose "View Target Data"

here is a basic query. I am sure someone will...

ChrisM@Work (10/1/2014)

---

Igor Micev (10/1/2014)

---

You can use this function

CREATE FUNCTION dbo.fnGetMonthDays(@myDate DATE) RETURNS INT

AS

BEGIN

DECLARE @isLeap INT = 0

IF (YEAR(@myDate) % 400 = 0 OR (YEAR(@myDate) % 4 = 0 AND YEAR(@myDate)...

You can use this function

CREATE FUNCTION dbo.fnGetMonthDays(@myDate DATE) RETURNS INT

AS

BEGIN

DECLARE @isLeap INT = 0

IF (YEAR(@myDate) % 400 = 0 OR (YEAR(@myDate) % 4 = 0 AND YEAR(@myDate) % 100 !=0))

SET...

Igor Micev (9/29/2014)

---

pietlinden (9/28/2014)

---

DECLARE @currMonthNum INT,

@lastDayMonth INT

SET @currMonthNum = DATEPART(MM, GETDATE())

IF @currMonthNum IN (1, 3, 5, 7, 8, 10, 12)

SET @lastDayMonth = 31

IF @currMonthNum = 2

SET @lastDayMonth = 28

IF @currMonthNum...

pietlinden (9/28/2014)

---

DECLARE @currMonthNum INT,

@lastDayMonth INT

SET @currMonthNum = DATEPART(MM, GETDATE())

IF @currMonthNum IN (1, 3, 5, 7, 8, 10, 12)

SET @lastDayMonth = 31

IF @currMonthNum = 2

SET @lastDayMonth = 28

IF @currMonthNum IN (4,...

No. Then it seems the issue is at the Excel side.