ZZartin (2/19/2015)

---

Eric M Russell (2/19/2015)

In the original post, it was stated that table contains no primary key. Regardless of what the table contains (datatypes or internal value structure), all tables...

MMartin1 (2/24/2015)

---

I for one like the yyyy-mm-dd notation. In other countries a '20140711' could be interpreted as Nov 07, 2014. If you changed the default language setting on your machine...

FYI:

If you're struggling with users entering "date" values into a varchar column in required format, the following check constraint enforces insertion of values as YYYYMMDD.

create table foo

(

...

It works for me when I first cast the string as date and then wrap a convert function around that.

PRINT convert(char(8),cast('Jul 11 2014' as date),112);

20140711

If no explicit constraint name is specified, then SQL Server will assign a random one at the time of object creation. It's best supply a constraint name so it's consistent...

Kutang Pan (2/23/2015)

---

I'm going to get my 7 and 5 y/o their own first PC, nothing powerfull, just something to be able to watch movies and stuff on internet. Maybe...

mw112009 (2/23/2015)

---

Hello and Good Day.

Below is a SQL statement that shows what columns belong to a certain view. My next question is how can I get a third column that...

PHYData DBA (2/23/2015)

---

bantrim (2/22/2015)

---

Eric M Russell (2/22/2015)

---

On occasion I've used: SELECT.. WHERE 1 = 0. For example, I may want to select into a temp table that is derived from...

I don't let my young kids go off exploring entirely on their own; not the neighborhood or the internet. But I do find ways to gradually and thoughtfully introduce them...

On occasion I've used: SELECT.. WHERE 1 = 0. For example, I may want to select into a temp table that is derived from another table but initially empty. Also,...

So, where does an Entity Framework developer land when you...

Regardless of where the remote server is located, so long as there is a LAN connection between, then latency is not an issue when pulling across hundreds or a few...

That's a self-answering question. If you want to do something more, then you have to become something else besides a senior level DBA....

jackson.fabros (2/19/2015)

---

I've read (and enjoyed) the original post that focused primarily on what a DBA should do on day one.

Aside from the obvious (stop, listen, take notes, repeat),...

OK

When a table is non-clustered heap, SQL Server adds...