chandrika5 (8/7/2015)

---

I have to do updates via web app. Stuck with time out:

Update mytable

set col1= 'some value',

...

mar.ko (8/7/2015)

---

For purposes of storing prices, total dollars, etc. and then computing grand total dollars via SUM, isn't best just to go with Money as the column data type ?

If...

For what it is worth, the text datatype has been deprecated since sql server 2005 in favor of varchar(max). If at all possible you should update your tables and stop...

halifaxdal (8/7/2015)

---

I asked previously if there is a way to isolate the portion that you need to search for. Thinking if you could parse that part into its own column...

halifaxdal (8/7/2015)

---

Sean Lange (8/7/2015)

---

halifaxdal (8/7/2015)

---

Sean Lange (8/7/2015)

---

halifaxdal (8/7/2015)

---

Thanks Sean.

The table contains daily data that to be analyzed to find out those fit into certain criteria, that's what the query is...

halifaxdal (8/7/2015)

---

Sean Lange (8/7/2015)

---

halifaxdal (8/7/2015)

---

Thanks Sean.

The table contains daily data that to be analyzed to find out those fit into certain criteria, that's what the query is for. I don't...

Well...the code you posted doesn't do anything but set some variables. You either need to share the rest of the code, or write that code that executes it.

halifaxdal (8/7/2015)

---

Thanks Sean.

The table contains daily data that to be analyzed to find out those fit into certain criteria, that's what the query is for. I don't know what else...

Luis Cazares (8/7/2015)

---

Jeff Moden (8/7/2015)

---

SQLRNNR (8/7/2015)

---

jasona.work (8/7/2015)

---

Another day, another "how do we prevent sysadmins from doing something" post. Which almost always boils down to essentially "we don't trust anyone,...

Lowell (8/7/2015)

---

Sean Lange (8/7/2015)

---

I was fiddling with a version of my own using that same function when Luis posted his. I scrapped mine immediately as I saw the approach he...

Lowell (8/7/2015)

---

just for reference, this is how i tried to solve it;

i parsed everything with DelimitedSplit8K, and then just fiddled with columns that were larger than the target length.

my...

halifaxdal (8/7/2015)

---

I just got a table with 16736580 records. Index is created.

A test shows a query like

select * from table where charindex(column, keyword) > 1

costs 14 minutes to return result.

I...

SQLRNNR (8/7/2015)

---

Sean Lange (8/7/2015)

---

ShorePatrol (8/7/2015)

---

Hi Folks,

I have some indexes over 30% fragmented. Some are much more...

I have a job maintenance plan to "re-organize" indexes every Sunday on all databases. I...

ShorePatrol (8/7/2015)

---

Thanks all -

I will check that page out...

But for clarification, is "rebuilding" an index better than reorganizing? I know I read somewhere that it was overkill to do...

ChrisM@Work (8/7/2015)

---

Grant Fritchey (8/7/2015)

---

j-1064772 (8/7/2015)

---

[font="Comic Sans MS"]One simple improvement would be to avoid DDL in the middle of DML statements.

Move to the top, before any DML the following:[/font]

[font="Courier New"]CREATE...