Jeff Langdon (9/13/2012)

---

Adam Haines (9/13/2012)

---

Even though the job reports success, I would still look at the agent history and in the second step from the top. There should be...

Scammers and Charlatans the lot of you!! 😛

May I recommend that you find a...

My understanding is that stats are not "swapped out" until they are complete - at which point stuff is marked as recompile. So your existing plan will keep getting...

GilaMonster (9/3/2012)

---

If you mean running tuning adviser and just accepting all suggestions without consideration, then no, it's not safe to do.

You need to make sure your profile trace included all...

Because I have delicate sensibilities, of course!! 😀

I also...

Personally I think that is a better query in...

Get/find articles/books by Itzik Ben-Gan that discuss the Gaps and Islands problems. He (and others) provide a range of solutions to this scheduling problem.

I am going to take what Gail said up a notch: it is utterly ridiculous for this client to ask you to set up their HA/DR stuff given that...

Jeff, why do you include LTRIM(RTRIM(OriginalString)) in your code? Isn't that (potentially completely unnecessary) work for nothing because your remaining code would handle any leading/trailing spaces anyway? Did/can you...

guerillaunit (8/16/2012)

---

Hi Kevin,

Is there a reason why you would need to drop the nonclustered indexes after truncating a table and before inserting new data to prevent fragmentation? I am...

Oops! Too quick read/reply.

I would use sys.dm_db_index_usage_stats, which does report user_seeks for your situation (at least with the test setup I did).

SQLSACT (8/8/2012)

---

Hi All

I'm struggling to understand why my Index is reporting Range_scans

DDL:

Table:

CREATE TABLE [dbo].[Indexing2](

[Col1] [int] IDENTITY(1,1) NOT NULL,

[Col2] [int] NULL,

[Col3] [int] NULL,

[Col4] [int] NULL

)

Indexes:

CREATE CLUSTERED INDEX [CX] ON [dbo].[Indexing2] ([Col1])...

Mark Eckeard (8/15/2012)

---

The load on the server shouldn't be high but we have almost 50 total locations, our network isn't exactly lightening fast and we have financial data that simple...

Since you are truncating the table first and then inserting rows, it is SIGNIFICANTLY better to drop the nonclustered indexes, insert the data, and then recreate the nonclustered indexes. ...