L' Eomot Inversé (9/23/2012)

---

It would be interesting to see the C# so that we could see what it is that's being optimised. Clearly either the C# optimiser is really...

Lynn Pettis (9/23/2012)

---

True. The problem is that I haven't been able to directly use any of the code Mr. Celko has posted recently because it doesn't parse. He...

PiMané (9/21/2012)

---

So it depends mostly on the data in the tables.

Being a "generic" software spread across the country we can have databases with customers mainly from one state (where...

All that is missing in a final close-parenthesis for the CREATE TABLE.

If you can live without the parent_column_id and is_system_named columns, the following will work:

SELECT name, object_id, principal_id, schema_id, parent_object_id,

type, type_desc, create_date, modify_date,

is_ms_shipped, is_published, is_schema_published,

object_definition(object_id) AS definition

FROM tempdb.sys.objects

WHERE type = 'D...

Yes it is a bug in the definition of sys.default_constraints:

CREATE VIEW...

I think the answer P.D. is after is [font="Courier New"]SELECT COUNT(*)[/font] It's not the shortest, though.

edit: Sorry I see 'mickyT' already mentioned this.

Sigh. I suggest these for part 2:

SELECT COUNT(*)

SELECT DAY('')

SELECT DB_ID() -- in master database only

That's just the SQL Server 2000 version of the same Books Online link to CAST and CONVERT...

This is documented in the Truncating and Rounding Results section of CAST and CONVERT in Books Online. The * means 'Result length too short to display'. This odd...

Ha, true. There again, the apple...

sidharthgs6, it is helpful to provide sample data using DDL statements as shown below:

CREATE TABLE #Example

(

Product character(3) PRIMARY KEY,

...

I'm...

It might; but it would have been more likely to if you had read this before replying:

EdA ROC (9/22/2012)

---

A little background about me and my situation. We...

PiMané (9/19/2012)

---

SQL Server has the MERGE statement and some people advise to use it instead of IF EXISTS with INSERT / UPDATE...Is it worth upgrading from IF EXISTS .. to...