A CONVERT to format 101 will give us format "mm/dd/yyyy". Then, using STUFF, we can remove the "dd/", leaving you with what you want:

SELECT STUFF(CONVERT(varchar(10), GETDATE(), 101), 4, 3,...

A basic maintenance plan is just terrible for large databases, because it rebuilds every table and every index regardless. You just can't waste that much I/O in a critical...

Many of us prefer to generate such code from the table itself, something like below. Uncomment the EXEC(@sql) when ready to actually run the code:

USE css

DECLARE @nonrepeated_cols nvarchar(max)

DECLARE @repeated_cols...

You could use subqueries instead of joins, like this:

SELECT

FI.*,

(SELECT TOP (1) C.ClassName_FD

FROM DBA.Class_TB AS C...

If you want just the company name returned, this should (will?) be more efficient:

SELECT [Company Name]

FROM dbo.CompanyInfo --#CompanyInfo

GROUP BY

[Company Name]

HAVING

MAX(CASE WHEN [Transaction...

Be sure to add a:

SET NOCOUNT ON

to the start of the trigger:

CREATE TRIGGER ... ON ... AFTER|INSTEAD OF ...

AS

SET NOCOUNT ON

...

And for a very minor efficiency gain you should add...

Michael Valentine Jones (1/29/2014)

---

Debora (1/28/2014)

---

Getting "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value." error when running the below script:-

delete from table

WHERE...

Luis Cazares (1/28/2014)

---

ScottPletcher (1/28/2014)

---

Don't convert to a datetime, just compare it as characters. Invalid data may still get through, but you can't easily at all correct invalid data on...

Don't convert to a datetime, just compare it as characters. Invalid data may still get through, but you can't easily at all correct invalid data on the fly in...

Define the index based on how you will query it, and the cardinality of the keys.

If you will always specify the second column in the conditions for the...

I think you can move the master db the same way for a cluster as you would for a stand-alone instance. Use the "SQL Server Configuration Manager" to put...

For uniqueness across servers, you can also use a second value, which can often be just a smallint, that identifies the original server that assigned the id. That way,...

You'll want indexes on the lookup guids. And, since they're guids, you'll need to rebuild the indexes fairly frequently. You should also strongly consider reducing the FILLFACTOR on...

If you can use online rebuild, it might be worth cancelling the current index create and running an online version.

Also, you should consider specifying other options -- or not --...

TheGreenShepherd (4/12/2012)

AddressParseStatus is nchar(1) and is used to indicate the value returned by our USPS validation software. It has pretty low cardinality, only 9 possible values. There are roughly 1B...