Usually, just counting the rows will give you a feel for whether the table is small. If you look at the table properties in SSMS and go to the...

What size are the tables that are still red? You don't really need to worry too much about fragmentation on small tables - let's say 1000 pages or less.

John

Try using SUBSTRING. There is a good resource here.

John

Eirikur

Good points there. Hence, my new improved version 2. I've padded out TimeDecimal with another two zeros (that deals with the small numbers), then converted to time and...

Raghavendra Mudugal (8/19/2014)

---

hmm, say you have a form of 10 text boxes, you enter a sequence of numbers, one in each box, you knew the start, you knew the end,...

Steve

Yes, I was being facetious about F5! But if it's the number of rows you're worried about, it's very easy to modify my test harness. I'm sure the...

sgmunson (8/19/2014)

---

And I have to wonder if your sample size is large enough. While the CPU time values for the string manipulation are less than half those of...

Normally, I'd agree you. On this occasion, however, the string manipulation appears to beat the...

Cast as char(4), put a colon in the middle, then cast as time.

John

Chandan

It's not entirely clear what your requirement is, but if I understand correctly, I think the simplest solution is to use a CTE or add a computed column to your...

TomThomson (8/18/2014)

---

There are cases where READ UNCOMMITTED isolation level is acceptable: the obvious case is the case where you know for certain, perhaps because a ban on certain actions at...

I recommend you investigate the reasons behind your performance issue before implementing this workaround. If you must do it, you can control the cluster from a command line -...

The important message appears to be "The device is not connected". What is your T drive - a local drive, a SAN drive, a drive with mount points, removable...

Look at the properties of the connection manager DestinationSCODatabase. What is the name of the server? What authentication mode does it use? If it uses Windows authentication,...

Prabhu

You haven't really given us enough information to help you properly. But what I would try is to list the columns in your SELECT statement instead of doing SELECT *,...