Viewing 15 posts - 5,521 through 5,535 (of 6,025 total)
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...
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...
June 29, 2011 at 11:27 am
PaulB-TheOneAndOnly (6/29/2011)
Eric M Russell (6/27/2011)
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.
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...
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...
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)...
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...
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? ...
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...
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...
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...
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...
June 24, 2011 at 1:15 pm
Jeff Moden (6/24/2011)
June 24, 2011 at 11:01 am
sqldba_icon (6/24/2011)Eric not sure what do u mean by that question but that is not under my control. There could be a way to reduce the number of records but...
June 24, 2011 at 9:01 am
Viewing 15 posts - 5,521 through 5,535 (of 6,025 total)