Viewing 15 posts - 5,536 through 5,550 (of 6,041 total)
OCTom (6/30/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 30, 2011 at 10:12 am
Revenant (6/29/2011)
Eric M Russell (6/29/2011)
. . . Even a RDBMS like SQL Server which is built exclusively on Win32/64 executables should be able to retain that functionality regardless of wether...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 29, 2011 at 12:31 pm
TravisDBA (6/29/2011)
opc.three (6/28/2011)
IceDread (6/27/2011)
I know.. but I still think it's a big flaw.
I am curious...I am not sure what you mean. Maybe it would help if I knew your standard...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 29, 2011 at 11:27 am
PaulB-TheOneAndOnly (6/29/2011)
Eric M Russell (6/27/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 29, 2011 at 10:14 am
Decades ago, mainframe computers were very mechanical and actually did use oil and hydraulic cooling systems for the disk storage systems. They even experimented with steering wheel input devices.
http://www.flickr.com/photos/maisonbisson/1634408/
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 29, 2011 at 9:56 am
opc.three (6/28/2011)
IceDread (6/27/2011)
I know.. but I still think it's a big flaw.
I am curious...I am not sure what you mean. Maybe it would help if I knew your standard for...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 29, 2011 at 8:00 am
Rebuild an index? What's wrong with it? Why didn't you do it right the first time?
"Changing the oil" is a good analogy for rebuilding the indexes, because indexes are something...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 29, 2011 at 7:30 am
Craig Farrell (6/27/2011)
...
I agree, and it sounds like someone used a temp table for logical ease then for optimization concerns. Moving to temp tables of any form (not CTEs)...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 27, 2011 at 2:11 pm
Actually, I think it may be possible for multiple SQL Server instances to share the same database files, but one requirement is that the database must be on a read-only...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 27, 2011 at 12:40 pm
Craig Farrell (6/25/2011)
Eric M Russell (6/25/2011)
Craig Farrell (6/24/2011)
...
Just to confirm, you're familiar with the fact that a CTE is nothing more then a subquery, and has no optimization value? ...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 27, 2011 at 11:13 am
Craig Farrell (6/24/2011)
...
Just to confirm, you're familiar with the fact that a CTE is nothing more then a subquery, and has no optimization value? It's merely there to allow...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 25, 2011 at 9:27 am
The decision of temp table vs table variable vs CTE or etc. depends on how this intermediate resultset will be leveraged within the stored procedure.
Where I've mostly used table variables...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 24, 2011 at 4:04 pm
GilaMonster (6/23/2011)
ankit.shukla1105 (6/23/2011)
I created two tables, VarChar_Table and Char_Table as below:
create table Char_Table...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 24, 2011 at 2:40 pm
Some types of events warrant not just logging or auditing, but sending an immediate notification to the DBA's attention. For example there is no good reason for the following errors...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 24, 2011 at 1:15 pm
Jeff Moden (6/24/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 24, 2011 at 11:01 am
Viewing 15 posts - 5,536 through 5,550 (of 6,041 total)