GilaMonster (4/1/2010)

---

all the threads have to complete before the threads can be combined. If some are slower than others, the threads that finished their work earlier have to wait for...

I had to guess based on very little detail in the first post.

DECLARE @Table1

TABLE (

row_id INTEGER NOT NULL

...

DECLARE @String VARCHAR(300);

SET @String =

'here is my phone number 1234567890. but my cell...

I usually use:

CHECKPOINT;

DBCC DROPCLEANBUFFERS;

DBCC FREESYSTEMCACHE('ALL');

Since you seem to be looking to measure physical reads, it can be useful to perform the tests with and...

hemalchalishazar (4/2/2010)

---

Thank you all for your response... The main reason why i would want to go for this removal process is to make my table data look more clean and...

Cockney Rebel

David-Leibowitz (4/2/2010)

---

Optimal is relative to what you're trying to accomplish. And there are always 20 ways to skin a cat.

I find it's always a balance between user needs and dev...

1. Change the EXECUTE AS clause

2. Create a certificate or asymmetric key, create a user from that, grant the required permissions to that user, then sign the procedure...

hemalchalishazar (4/1/2010)

---

I am working on a big table with around 600 columns and 33000 rows.... now for each column there are values in around 500 rows and rest of...

DECLARE @Table

TABLE (

id INTEGER IDENTITY PRIMARY KEY,

data...

Awesome! Very...

vaibhav.tiwari (4/2/2010)

---

I was asking that if i will use your query then it will give me null for all invalid date but that might be possible that that invalid date...

Neither does anyone else...so far. Give it time 😉

Hmmm. Interesting enough for its SSRS focus, but it only covers one possible...

DECLARE @Table1

TABLE (

row_id INTEGER PRIMARY KEY

);

...