Assume you are running Enterprise edition, otherwise DBCC CHECKDB does not do parallel execution and obviously the Resource Governor is also an Enterprise...

jeffsaks (1/12/2016)

---

Love your forum!

Here's the story.

I have 20 computers running an MS ACCESS application, all connected via ODBC (SQL Server Native Client 11.0) to a SQL Server 2012.

Everything works great,...

You are very welcome and thank you for the feedback.

😎

The two queries are not equal,SELECT * FROM information_schema.ROUTINES will return all routines regardless of the type, filtering on ROUTINE_TYPE = PROCEDURE will still return CLR procedures which SELECT *...

Phil beat me to it 😉 Here is a slightly different version

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(HearingDate,HearingTime)

AS (SELECT CONVERT(DATETIME,X.HearingDate,120),HearingTime FROM (VALUES

('2001-10-06 00:00:00.000','0830')

,('2010-02-22...

sys.all_sql_modules stores all sql modules, comparing tables it a bit more of a task, strongly suggest using 3rd party tool such as SQL Compare for this. A option could be...

snomadj (1/12/2016)

---

I don't know access but I have an access db that somehow interfaces with an old SQL database I need to move.

So I need to figure out how the...

Missing root note reference and root note namespace

😎

Another way is to use XMLNAMESPACES

DECLARE @TXML XML...

decreale (1/12/2016)

---

I am trying to execute the following script but need to pass two parameters, I'm not sure how too, I know the script works with a stored procedure not...

You are very welcome.

😎

Hugo Kornelis (1/11/2016)

---

GilaMonster (1/10/2016)

---

Sure, with the same general idea.

t1 INNER JOIN t2 on t1.Col1 = t2.Col2 OR t1.Col1 = t2.Col3 OR t1.Col1 = T2.Col4

Don't know what the performance will be,...

Steve Jones - SSC Editor (1/11/2016)

---

Grant Fritchey (1/11/2016)

---

Continuing my role as the harbinger of death, Ziggy Stardust is no more.

One of my favorite songs. Although Bauhaus actually did it...

Match

have2much (1/11/2016)

---

I want to do this because dbcc command waits for very long time with waittype CXPACKET, when I tried running it with MAXDOP 1 all the wait time is...

Lynn Pettis (1/11/2016)

---

Eirikur Eiriksson (1/10/2016)

---

rahulsahay123 (1/8/2016)

---

I am getting a data feed with date column of type integer.Format is mmddyyyy.

Values are like : 01092015

Now i want to convert...