Viewing 15 posts - 5,446 through 5,460 (of 6,041 total)
In both SQL Server and Oracle, the ROWID is a physical marker that changes when the physical position of the row in the page or table changes. For that reason,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 2, 2011 at 8:21 am
allonlineaccts (7/31/2011)
I am responsible for developing and editing user interfaces for several departments. These interfaces allow the end...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 1, 2011 at 12:43 pm
From what I've seen, most outages (an extended period of time where all or a large number of users cannot access the application or some key feature of it) are...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 1, 2011 at 9:28 am
mar10br0 (7/29/2011)
Eric M Russell (7/29/2011)
mar10br0 (7/28/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 1, 2011 at 6:33 am
umailedit (7/29/2011)
I have become skeptical of "scientific" findings regarding food and medicine. There seems to be scientific studies backing every cockeyed conclusion both for and against.
I saw an infomercial...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 29, 2011 at 9:28 am
I'd say that SQLServerCentral is a geeky distraction. 😉
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 29, 2011 at 8:27 am
cy-dba (7/29/2011)
I've been watching various movies via Netflix (streaming and DVD), especially documentaries.Is anyone else wondering when Iron Fist will come out on the big screen??
There are a lot of...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 29, 2011 at 7:32 am
I've been reading through the Sword Of Truth series for several months. Also, from these books the TV series Legend Of Seeker was adapted.
http://en.wikipedia.org/wiki/The_Sword_of_Truth
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 29, 2011 at 6:38 am
mar10br0 (7/28/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 29, 2011 at 6:24 am
Ninja's_RGR'us (7/28/2011)
TheSQLGuru (7/28/2011)
3) BEWARE DTA!! It does numerous bad things with indexing.
I've actually had DTA CRUSH the server's CPU (large load) and then fill up the drive by growing...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 28, 2011 at 3:12 pm
The optional Power Pivot addin (reuquires Excel 2010) can analyze millions of rows. You don't need to import millions of rows into Excel to analyze the data using Excel. Rather...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 28, 2011 at 11:49 am
Nadrek (7/28/2011)
Eric M Russell (7/27/2011)
How would you leverage ROWID for detecting "overlapping date ranges"; doesn't that typically involve comparing two or more date columns?
It's the trivial case of "exclude each...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 28, 2011 at 10:38 am
Nadrek (7/27/2011)
Eric M Russell (7/27/2011)
Nadrek (7/27/2011)
Actually, I'd very much like it to be exposed; for certain cases (say, overlapping date range detection), having an efficient, guaranteed unique per row value...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 27, 2011 at 2:03 pm
Nadrek (7/27/2011)
Eric M Russell (7/27/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 27, 2011 at 1:23 pm
Steve Jones - SSC Editor (7/27/2011)
Eric M Russell (7/27/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 27, 2011 at 12:04 pm
Viewing 15 posts - 5,446 through 5,460 (of 6,041 total)