SQLKnowItAll (6/4/2012)

---

Here is a script that I use, though I can't find the reference to it so I cannot give credit. However, I did not write it:

select

obj.name...

yes.

I have created two partitions, one with 1000000 records and one with...

Thanks for your help !

Update:

My DB copy on my other server is fine, no errors 🙂

So it is looking like it was the RAID controller or backplane issue !

I did have some recent issues with either my RAID controller, backplane or both, so Dell replaced them both.

I will check another copy of the DB running on...

I just attached the report.

Thanks

Per your request, i have attached an error report.

Thanks

I typically run a weekly backup, its not a production DB yet, and i have never had any errors.

Since my backups have never produced any errors, i have never run...

SQL Kiwi (5/25/2012)

---

isuckatsql (5/25/2012)

---

I removed the reference to "AllRecentWages" and got 850k records in 10 seconds, so that was certainly a big part of the issue! Now i need to...

USE [JobPortalIAN]

GO

/****** Object: StoredProcedure [dbo].[GetAllResumesSearchedDynamicQueryBUP5-25-12Test] Script Date: 5/25/2012 4:14:49 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- ============================================= ...

Guys,

Thanks for the assistance!

I removed the reference to "AllRecentWages" and got 850k records in 10 seconds, so that was certainly a big part of the issue!

Now i need to figure...

Test two, 474k records in 29 seconds!

Test One 343k records - one second

That is what i was concerned about!

Thanks anyway 🙂

I noticed that the Column Store index is quite selective regarding data types and included fields.

Does anyone know if running the Actual Execution Plan in SQL Server 2012 is 'smart'...