Jeff Moden (4/28/2014)

---

ahmed_elbarbary.2010 (4/28/2014)

---

Hi guys i want to make database for payroll only but i don't know how to make structure for this

suppose i want to calculate payroll every month...

I usually say I'm a Database Architect, or anything that will make people think that I'm not the guy to troubleshoot problems with their PC or help them setup their...

Because they would rather have bad data in the database than track down those annoying FK errors?

As you probably know already, this is a very complex problem, especially when you are dealing with multipart names, non-western names, etc.

You may want to invest in commercial software that...

if object_id('dbo.tablename','U') is not null begin drop table dbo.tablename end

go

create table dbo.tablename(

IDintnot null identity(1,1) primary key clustered,

SDatevarchar(10) not null

)

go

ALTER TABLE dbo.tablename ADD CONSTRAINT CHK_Date_format check

(case when SDate not...

WayneS (3/28/2014)

---

Ed Wagner (3/28/2014)

---

WayneS (3/27/2014)

---

Luis Cazares (3/27/2014)

---

How is it possible that someone writes a cursor instead of using SUM()?

I'm afraid that this database is full of these pieces of sh...

Luis Cazares (3/28/2014)

---

I'm a developer/programmer/moroff/slave and for that reason, I wonder why people like to overcomplicate things if they have the tools available. Next thing, I'll hear about someone making...

Probably need to hear more of the justification, but I doubt that there will be any money savings from going to DB2, even without the cost of the conversion.

There aren't many people that...

Get Server Database File Information

This script gets the file information for every database on a server, and inserts it into temp table which is then queried multiple ways to give...

TheGreenShepherd (2/14/2014)

---

Yeah, I know, it's non-SARGable. That was really my last line of defense for shooting this idea down, because his next suggestion is to make that column non-nullable, and...

I am not sure what "overnormalized" even means, but anytime someone said that...

JeeTee (2/12/2014)

---

Hi SSC,

...

Yesterday, a senior database developer colleague of mine described the use of foreign keys as "purely academic" citing that FK's provide little benefit that can't be enforced through...

It is not uncommon for the PLE to crash to a very low number for a while if you run a query that requires a lot of data to be...

I prefer to include the object type parameter in the OBJECT_ID function call to make sure it is actually a temp table, and not some other type of temp object.

In...