ricardo_chicas (2/8/2012)

---

I already did that, the execution time was the same...., the query is too simple, I think the problem is the size of the table and the amount of...

L' Eomot Inversé (2/9/2012)

---

MysteryJimbo (2/9/2012)

---

HowardW (2/9/2012)

---

MysteryJimbo (2/9/2012)

---

Interesting fact: Historically, it used to be in the UK that people drank more beer than water as it was sterile and the water...

Be vewy vewy qwiet, we're huntin' wabbits.

ricardo_chicas (2/7/2012)

---

Hello all

I have a very large table ( 338782585 rows, 552 gb ) , usually it is "fast" to retrieve data from it, but I have an special case...

Don't use between.

Use something along these lines:

DECLARE @param1 DATETIME, @param2 DATETIME

SELECT @param1 = '20120101',

@param2 = '20120129'

SELECT * FROM tbl...

Lucky9 (2/7/2012)

---

Thanks a lot for the quick reply Evil Kraig.

I have tested the query provided by you it works fine for the first and third record but the output for...

Like so:

Create table #TestClient

(ID int,

InternalCode nvarchar(100))

Insert into #TestClient values(1,'abctest12-2-1-12345-12-01-08')

Insert into #TestClient values(2,'xyztest24-1-2-2345-2013-1-5')

Insert into #TestClient values(3,'QRStest69-2-3-34568-05-1-09')

Insert into #TestClient values(4,'TUVtest99-9-8-56789-2011-9-10')

select * from #testclient

select SUBSTRING( InternalCode,

CHARINDEX( '-', InternalCode,

CHARINDEX( '-', InternalCode,

CHARINDEX( '-',...

I assume...

Sure. In perfmon (Performance Monitor) there's...

wilson_acong (2/7/2012)

---

The p0 table is clustered index on VISITOR_ID ASC too.

The Recovery model is Simple. Whole data size is approx close to 301GB

Yes, I need all the data. Because we...

Seriously? Would you like to be the pot, or the kettle, for the remainder of that conversation?

Koen Verbeeck (2/7/2012)

---

Lynn Pettis (2/7/2012)

---

Now that it is officially posted on facebook, I can start telling everyone.

Kassondra gave birth to a healthy baby boy yesterday in Germany. Grayson Matthew was...

Be aware that lookup is case sensitive. You may need to use a wrapper on your columns to turn them all to UPPER (I usually use a derived column...

justintime (2/7/2012)

---

I am creating a new report using a stored procedure that was provided to me by a business partner. Using BIDS 2008 I am encountering the following error....

You're not off Jessie, but it will depend on the version of the SQL Server if it will use the view indexing or bypass to the tables depending on your...