Abhilash T (6/3/2012)

---

Hi All,

I have a table with lots columns(all columns not included here).

CREATE TABLE DBO.DAYSPECIALS(

DAYSPECAILSKEY BIGINT ,---PK FIEL

........ --SOME INFO COUMNS

ISAPPLIEDFORSPECIFICDAYS BIT,

ISSUNDAY BIT,

ISMONDAY BIT,

ISTUESDAY BIT,

ISWEDNESDAY BIT,

ISTHURSDAY BIT,

ISFRIDAY BIT,

ISSATURDAY...

I understand that the goal is to translate voice commands into web search or iPhone commands, but I don't see why it's necessary to steam the actual voice over to...

hisakimatama (6/1/2012)

---

Hm, 5 to 7 years? Not too bad :-). I can suffice off of what I make now pretty well, so there's no rush at the moment....

In the case of...

I was just about to post the same question.

Based on the logical...

I've actually never leveraged sp_getapplock nor even encountered it, and I've seen a lot of databases code. However, I have seen situations where developers have implemented their own concurrent "locking"...

It's rare that I'll see a truly great science fiction film. What I'm talking about is a film that's a great adaptation of a great sci-fi novel. Most of the...

allmhuran (5/10/2012)

---

...

COMMAND LINE BASE SOLUTIONS

OPTION: output to text file using bcp/sqlcmd

ISSUES: prone to special character problems, like tabs, commas, newlines etc embedded in large text coulumns such as memos,...

A couple of weeks back, I went to see "Mirror, Mirror" with my wife and kids. I went into it with only luke warm expectations, but it actually turned out...

My first guess is that it would be the result of index fragmentation or page splits.

SQL Server Fragmentation The Basics

http://www.brentozar.com/archive/2009/02/index-fragmentation-findings-part-1-the-basics/

Also, you may want to consider moving your LOB...

How to troubleshoot a Msg 823 error in SQL Server

http://support.microsoft.com/kb/2015755

To start, SQL Server 2008+ contains a system table called SUSPECT_PAGES that maintains information about suspect pages and their error...

Markus (5/16/2012)

---

Not enough really. I don't think a CIO/CEO would say that is acceptable if someone wreaked havoc on that SQL Server install or stole data from it and...

Markus (5/16/2012)

---

The big problem with running it beyond 2014 is that if a virus comes out that effects SQL2000 Microsoft will no longer create a fix for it. THAT...

No, it's not necessary. Having LoadDateTime + ID would just be an alternative...

Elliott Whitlow (5/10/2012)

---

Lynn Pettis (5/10/2012)

---

Guess I'd fail here. First things I look...