The last replies have been to have a db per customer in your set up. That's the one I would go for for simplicity of management, upgrades, specific client tailor...

My rules of thumb for date/datetime data:

1) always store in the appropriate data type (date / datetime)

2) don't put functions on columns, so if you need e.g. 23 year old...

just my 2ct to add ...

it also depends if you have more than just NULL/0/1 ( e.g. you want to know if the data "is being prepared" or "is being...

your backup database command isn't initializing the bak file.

Things to check:

- the @BackupPath backup file name composition (as it still has the same name as the day before, and...

suppose _you_ know the matching criteria, and only want to know if rows defer ... have a look at checksum and only show rows that have non-matching checksum values for...

- How about windows 7/2008(r2)

- networking basics

- communication skills

Keep in mind if your date columns are of datatype datetime don't use BETWEEN but use

col >= @begin and col <= @end

SQLServer has an issue with datetime data typed...

except for the bad choice of the stored procedure name [SP] posting the code of the sproc would help us helping you very much.

Nice article. And what's most important .... It will help people diagnose and solve this kind of issues !

With fixed ports, you can also register the spn yourself ( after...

With your jobs, also keep in mind to check your db-state in a first step ...

cfr

if exists ( select 1

from sys.database_mirroring

...

If you cannot relate to a change at application side, or db server software level side, I would double check all physical drives this server is connected to.

We've had a...

Now there's a definite "it depends" 😉

Would you expect your db to consume the freed space fairly soon ? Don't shrink it. You'll save the extention overhead if sql needs...

your sequence doesn't contain re-creation of the objects you dropped before altering the CLIX (NCI, constraints, FK-indexes,..)

Here's another great resource by Brent Ozar that may get you on track tackling potential problems with san configurations for sqlserver

http://www.brentozar.com/sql/sql-server-san-best-practices/

other factors that can influence performance:

- concurrent connections/users (b)locking on objects

- tempdb IO and tempdb sizing

- not using set based approaches

- organization of your tables, indexes, indexed views, ...

- over...