you have to update statistics on all tables with full scan after a version upgrade, or restore of a database from a lower version to a higher;

the statistics are treated...

whoops after reading your post AFTER i posted, i see you really want to chop up the string based on a fixed length(ie 4 chars)

well, i know an example of...

check out this thread that has both a scalar and an inline table value function that resolves the same issue: splitting a string on a delimiter into new columns:

http://www.sqlservercentral.com/Forums/Topic1524275-3077-1.aspx#bm1524325

i thinka decent rule of thumb for most SQL installations reserving 1/8th of the memory for the OSand apps, and 7/8ths for SQL server, plus or minus any special needs;...

you want to take advantage of the OUTPUT clause, which gives you access to the INSERTED and DELETED triggers that are normally seen inside a trigger;

here's an example, where i...

well, SQL requires a paridigm shift here: you process everything in a set, and not loops;

there's a phrase in SQL called RBAR (Ree-bar) meaning Row By Agonizing Row, which is...

I modified this from somethign i saved in my snippets that is associated to the same issue: split a string on a specific number of character lengths.

if you search for...

well, i dunno about the kudos, but thank you,...

the extra STUFF is how most of us remove the delimiter;

while in this case, you could use LTRIM becasue we used a space, for any other delimiter(comma delimiter, pipes,...

ok i have this example in my snippets for turning CamelCase into a single string with spaces:

now, if each word becomes a column unto itself, that's tougher...

that would have to...

GilaMonster (12/20/2013)

---

Lowell (12/20/2013)

---

» in an actual execution plan, for any node, if the actual number of rows is orders of magnitude higher than the estimated number of rows, the statistics...

Oracle_91 (12/20/2013)

---

Hi Pals,

Assuming the query execution is slow , I have collected the actual execution plan. What should I look for in the actual execution plan . What are the...

a backup will almost always be larger than the maximum allowed attachment size for most mail servers; of the two mail servers i use, one has a limit of 4...

ramana3327 (12/19/2013)

---

If I took Basic authentication and gave gmail account as user name & Gmail account password in the password then it is working fine but if I use windows...

it's an oracle function that you'd access via a linked server then?

that's a different story, i must have missed that part.

you have a linked server in place already?

ie, from SSMS,...