Viewing 15 posts - 5,131 through 5,145 (of 6,041 total)
Abhilash T (6/3/2012)
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 4, 2012 at 12:47 pm
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 4, 2012 at 8:40 am
hisakimatama (6/1/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 4, 2012 at 7:23 am
Steve Jones - SSC Editor (6/1/2012)
Ugh, my apologies. In the copy/paste, I lost C somehow.The option was supposed to be c) get me out of here ASAP
In the case of...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 1, 2012 at 8:37 am
Christopher Reed (5/31/2012)
Steve,I'm just curious. What was "c"? You never listed it in the editorial.
I was just about to post the same question.
Based on the logical...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 1, 2012 at 7:44 am
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"...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 25, 2012 at 2:58 pm
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 25, 2012 at 7:23 am
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,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 25, 2012 at 6:33 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 25, 2012 at 6:01 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 22, 2012 at 8:28 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 22, 2012 at 7:44 am
Markus (5/16/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 16, 2012 at 7:05 am
Markus (5/16/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 16, 2012 at 6:49 am
rafael_si (5/14/2012)
Hello Eric,Since my business key do not duplicate, the identity column is not necessary, is it?
No, it's not necessary. Having LoadDateTime + ID would just be an alternative...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 14, 2012 at 12:28 pm
Elliott Whitlow (5/10/2012)
Lynn Pettis (5/10/2012)
Anyone tuning the query by not looking at IO and Time statistics and query plan would immediately fail.
Guess I'd fail here. First things I look...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 10, 2012 at 12:23 pm
Viewing 15 posts - 5,131 through 5,145 (of 6,041 total)