SQL33 (11/4/2010)

---

I've been investigating this syslog parsing problem further, and noted using my HEXEditor that the field I need to have parsed (the MSGText field) is actually internally delimited with...

Michael Valentine Jones (11/4/2010)

---

There is a nasty gotcha to watch out for if your application is doing connection pooling: The transaction isolation level does not get reset by sp_reset_connection, so...

Michael Valentine Jones (11/3/2010)

---

I mainly wanted to show the logic for how to handle this: "(If date of month >=15 will count as whole month, if <15 will be ignored)...

<------------- Okay, I earned one of these...

Michael Valentine Jones (11/3/2010)

---

What you are missing is the following from SQL Server Books Online under the SET DATEFIRST topic:

When you have @@DATEFIRST =...

SQL-Tucker (11/3/2010)

---

Thank you, that is a HUGE help and gets me on the right track.

At this point I either need to rethink my approach and handle the conversion on the...

Hold up. Force Order is letting...

The optimizer doesn't promise it's going to do anything in a specific order, just the fastest it can figure out.

The WHERE clause is a good start, but the issue here...

Demin, you're aware that's not proc based, right?

To help with the query(s) in question, we'd need to see schema, script, and execution plans. Check out the 'optimization' link in...

WayneS (11/3/2010)

---

Craig Farrell (11/3/2010)

---

This might need to be run multiple times... you can't drop a table that is a parent in a FK relationship, so you might need to wait...

I've got two reasons I've done it in the past, mostly scenario specific though.

1) Dev database, and...

DECLARE @startDate DATETIME,

@EndDate DATETIME

SET @StartDate = '09/01/2007'

SET @EndDate = '05/20/2009'

SELECT

N AS [Year],

CASE WHEN N = YEAR( @StartDate)

THEN DATEDIFF( mm, @startdate, DATEADD( yy, YEAR( @StartDate) - 1900 + 1, 0))

WHEN...

Sorry, reading back that was a bit rougher sounding than the joke I meant it to...

raistlinx (11/3/2010)

---

Depending on what kind of a RAID environment you may be working in (often beyond your control) it can take a lot longer than that. So let's suppose...

Some very brief google research:

Run the webservice as admin:

http://database.itags.org/sql-server/274814/

Same starter post, more clarification at the end, needs fully trusted in .NET:

http://www.windows-tech.info/15/35c56638890ee860.php

Some information about custom assemblies which I don't fully understand...

Offhand, without integrating it into your code (or testing this pseudocode, for that matter, just trying to give you an idea):

You'd use the CHAR() function which turns a numeric into...