GilaMonster (1/24/2013)

---

CREATE PROCEDURE search_orders @custid nchar(5) = NULL,

...

The referenced article also has plenty of mistakes. :laugh:

Ask Ars: Why will Apple's Do Not Disturb bug fix itself next week?

http://arstechnica.com/apple/2013/01/ask-ars-why-will-apples-do-not-disturb-bug-fix-itself-next-week/

For example:

"The first day of 2013 started on a Tuesday,...

Steve Jones - SSC Editor (1/22/2013)

---

This is...

Generally speaking, you will not see much improvement from having multiple tempdb files, except under specific conditions that are fairly rare.

When you are allocating an extremely high number of temp...

bugg (1/22/2013)

---

...

After a bit of research I don't really want to use SNAPSHOT ISOLATION or READ_COMMITTED_SNAPSHOT as this approach would require downtime to alter the database and possibly loads of...

SQLRNNR (1/17/2013)

---

There is a way, but while hashing that out I just want to bring up a preference. I prefer to have the date and time on the backup...

Were there any changes to application code or stored procedures?

Is it possible that the database was altered to set read_committed_snapshot on?

Is is possible that the users just stopped using the...

String '2012-11-21 16:36:53.850000000' is too long to convert directly to a datetime value.

This code shows a couple of ways that work:

declare @date_str varchar(50)

set @date_str = '2012-11-21 16:36:53.850000000'

select ConvertLeft13 = convert(datetime,left(@date_str,23))

select...

I was expecting a different kind of fun with ACID.

When I was in the 8th grade we noticed one day after school that all the teachers were in a meeting...

As a start, I suggest changing the primary key ,[isel_pk], to clustered with a fill factor of 80 and changing the index [isel1_dx] to a fillfactor of 80.

Also, one of...

That table definition can't be right, it has two primary keys defined.

Markus (1/15/2013)

---

Interesting thoughts, thanks.

Has anyone done any comparision to the SQL2008R2 backups with compression as far as time taken to run and size of backup and compared it to, say...

It will probably be far faster to filter data in SQL Server.

Escorts are well paid, have flexible hours, and can be full time or part time.

AllHype (1/14/2013)

---

I'm trying to figure out how to return records from the previous month up to the 10th of that month. This process will be on going for each month...