Sachin 80451 (5/23/2012)

---

I have the following scripts which gets me all the data from a table. But I want to shows months such as December and January which currently dont...

this is something that itzik ben-gan demos at some of conferences he talks at

he's doesn't say don't use read uncommitted, just know when and where to use it and be...

perry - could you post the update command you are trying to perform, and also the structure of the table and all indexes on it.

we can't really assist without this

i tried the following and found by turning on Client statistics and sql profiler that my version using RIGHT performs consitantly better by a very small margin

create table #temp(emailid varchar(100))

insert...

Usman Butt (5/23/2012)

---

First of all, let me make it clear, I am not against the CLR integration at all 😉 It serves much better than TSQL in some scenarios.

But...

krypto69 (5/22/2012)

---

I have a local site (production) and I have a DR site located many states away.

Thanks to the help from this site, I setup mirroring. Which worked fine until...

SQL Kiwi (5/23/2012)

---

dwain.c (5/23/2012)

---

I've seen (dramatically) how WITH SCHEMABINDING improves the performance of a Scalar Valued Function. I'm wondering if the same is true for TVFs and what is...

from the link i posted - hence my original posting

A database mirroring session runs with either synchronous or asynchronous operation. Under asynchronous operation, the transactions commit without waiting for the...

my bad there (oops) - i was just trying to find the link that describes the difference between high performance and high safety and accidentally hit post!

see the following link

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

post deleted because it was wrong (oops) 🙂

the other thing to consider is do you want to do CI (continuous integration) builds on your checked in code......

ah yes - i forgot to mention that...

Team foundation server 2010 is pretty good, but maybe wait for 2012

if your organisation is too small to afford TFS then you can't beat Subversion (SVN) and Tortoise

with SVN...

+1 - see the following on how to get your data into 1st normal form

http://en.wikipedia.org/wiki/First_normal_form

try this and see if it matches

create table #temp (mydata varchar(20))

insert into #temp select 'ABCDEF?/??GHIJK'

select * from #temp

drop table #temp