SQL DBA-909494 (11/6/2014)

---

Hi,

I am looking for a script which will help me to capture the object details like constraints, clustered & non-clustered indexes, primary & foreign keys, etc before migration...

qinzhen (11/6/2014)

---

hi.

I have a lot of txt files with data that I need to import. They are "|" separated data files.

Some of them have the columns like...

Yes, stay away from the red one:-D

So here's a question...

Let's say...

occasional sql (11/6/2014)

---

I want to be able to return the rows from a table that have been updated since a specific time. My query returns results in less than 1...

ramana3327 (11/6/2014)

---

The reports are taking long time. Once I restart the server, the report time come down. The report is using the default parameters for the sp. After the restart...

Quick question, are you using Remote BLOB Storage (RBS)?

😎

Just for fun, a computed column solution:-)

😎

USE tempdb;

GO

SET NOCOUNT ON;

CREATE TABLE dbo.TBL_COUNT_TO_THREE

(

CTT_ID INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_DBO_TBL_COUNT_TO_THREE_CTT_ID PRIMARY KEY CLUSTERED

,CTT_VAL VARCHAR(50)...

harrietf (11/6/2014)

---

When I look at the C drive properties of this server, which is used only as a Sharepoint - Intranet server, it appears as if 85% of the drive...

Gazareth (11/6/2014)

---

I actually encountered this exact behaviour last weekend. Got me a bit worried!

My explanation would be that the CTE is never materialised as such, so the rn value is...

:blush: just noticed, had several "versions", this one is no good

😎

Quick thought, there are actually two row_number instances in the plan, one used for the delete and another for the output. As only one row is outputted, the row number...

Alan.B (11/4/2014)

---

Taking this one step further... Why not just replace PatExclude8K with PatReplace8k() ?:w00t:

I like the idea, tinkered a little bit with the code and got the average execution time...

Less than five minutes in vi, slightly more in notepad++

😎

Further on Koen's question, restarting the service is not a blanket solution, in fact the same principle applies here as elsewhere, why "fix" it if it isn't broken? Also you...

Hi and welcome to the forum.

Further on Stewart's answer, have a look at this article, Detecting and Ending Deadlocks

Avoiding deadlocking is best done by design, making certain that resources...