I agree, it's a pain. It's something they fixed in PowerShell 3.0.

I just drop right into my loop if I get a result and it handles it, but I do...

Column stats is the likely reason given the info.

foxxo (1/16/2013)

---

It wasn't the statistics that fixed the issue, it was the query being recompiled (ie. new plan).

From BOL:

http://msdn.microsoft.com/en-us/library/ms187348.aspx

Updating statistics ensures that queries compile with up-to-date statistics. However, updating statistics...

Kickoff a proc in Sybase and then copy some data from a table to SQL Server when the proc is done? Sounds like an easy job for SSIS. The hardest...

USE AdventureWorks2012;

DECLARE @schema_name SYSNAME,

@table_name SYSNAME;

SELECT @schema_name = N'HumanResources',

@table_name = N'Department';

SELECT st.name AS StatsName,

...

I just came back to this and found that you cannot use a temp table in a classifier function, meaning I cannot see a way to use sys.xp_logininfo directly to...

The ACE drivers are not standard equipment on Windows Server 2008 so in case you;re looking for them you can download a 32 or 64-bit version here:

http://www.microsoft.com/en-us/download/details.aspx?id=13255

I am not a huge fan of Linked Servers mainly because of quirks like this. You may not want to hear this because your process worked for years prior to...

rynmthw3 (1/14/2013)

---

What if rather than SUSER_Name()=...

kenambrose (1/15/2013)

---

The real limitation is that oledb destination can't support dynamic data structure in addition to source and target tablenames- or at least I can't figure out how to do...

I was really surprised at how poorly the RegEx did compared to MailAddress. I am now wondering what MailAddress uses to determine validity.

Here are a couple TVFs to go along...

The logic looks OK to me. Is this homework or a real-world scenario? If real-world then consider adding a transaction boundary around proc1 and proc2 so that if proc2 encounters...

Ill Communication

kingdonshel (1/15/2013)

---

I was wondering has anyone ever written a regular expression thatreurns a boolean for wether a phone number is a valid phone number in the US...

Leveraging the validation built into the System.Net.Mail.MailAddress constructor is clever and I did not have to set trustworthy on to use it. The RegEx version is nice too. I wonder...