well going forward, you could add a check constraint...

The only way to make it perform better is to make the search terms Sarg-able and index-able, as John referred to, otherwise you are stuck with a table scan.

you could...

Adam i think just doing UNION or UNION all would probably be better than the OR statements ; one of those simple fixes that should have a perfroamnce imact:

SELECT ..

LEFT...

you'll want to look into using the OUTPUT clause so you can capture the new identity values, along with your data, so tyou can isnert/update the second table.

here's just one...

read up at Gails blog on catch all queries: http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

here's an example of a catch all query:

WHERE 1 = CASE

...

i've added Phil Factor's Regular Expressions CLRs[/url] to my servers for a while now ;

in several of my projects, the regular expressions, since they are inline table value functions, are...

nice job providing the sample data!

in this case, you need to get the "sets" organized first so they can be compared.

Someone else may have another method, but i thought using...

hayden_jones (1/31/2014)

---

I have a report to run every day in SSMS. I have selected query options to send results to a file with pipe delimited results. Tomorrow, I...

here's one that i just got bitten with and added to my common checks:

i added a filtered index, and a stored proc that updated the table with the...

ok in that case, what you want is a certificate signed stored procedure.

then the credentials of the certificate are used, and that can satisfy the cross database/instance permissions issue, i...

you can never restore a higher version db to a lower version;

looks like your db is 2008 but you are installing/using SQL2005. check to see if you installed an isntance,...

evansrf (1/30/2014)

---

I'm having trouble understanding the requirements for this.

I'd like to have a stored proc that selects/updates a distributed partitioned view.

I really don't want to have to grant rights to...

I think you simply want SET @Day = cast( getdate() as date)

you have a DATENAME function that would reurn 'FRIDAY", which you tehn try to cast as a date, and...

ok i got a lot more data than the ten or so rows you displayed, but this seems to do it.

you might need to grab a vopy of DelimitedSplit8K

http://www.sqlservercentral.com/articles/Tally+Table/72993/

;WITH MyCTE([clndr_id],[clndr_data])

AS

(

SELECT...

interesting; so you need to find multiple substrings that are like 'd|[0-9][0-9][0-9][0-9][0-9]' ie '(d|41519)'

here's a cte of his post for the adventurous;

i'm trying a lazy DelimitedSplit8k cross apply...