Viewing 15 posts - 2,896 through 2,910 (of 7,164 total)
Jon80 (10/14/2012)
Thanks, however, there does not seem to be a 32 bit version of Windows Server 2012, is there?
Nope. 64-bit hardware is required for Windows Server 2012. This has been...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 17, 2012 at 9:20 pm
Check for single use plans.
Plan cache, adhoc workloads and clearing the single-use plan cache bloat by Kim Tripp
I had to implement a variation of one of the queries in...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 16, 2012 at 4:12 pm
The technique Eugene relayed will work great, especially if you do not have a unique key on the original table. However if you do have a unique key and it...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 16, 2012 at 5:25 am
The OS is not the determining factor, the bitness of SQL Server is. If SQL Server is 32-bit running on a 64-bit OS then AWE can be enabled in SQL...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 12, 2012 at 10:24 pm
For SQL 2005 a third-party backup tool that does compression on the fly (like RedGate Hyperbac or SQL Backup Pro) will be a good investment. Upgrading is expensive inother ways,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 12, 2012 at 9:56 pm
Bhuvnesh (10/10/2012)
looping myself
FYI you can use the Topic Options button on the top roght of each forum page to Subscribe to a topic without posting.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 11, 2012 at 10:20 pm
SSIS needs a concrete table to build metadata from when designing the DFT. Try using a concrete table for design then changing the package to use a temp table at...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 11, 2012 at 8:46 am
steveo1967 (10/10/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 10, 2012 at 7:41 pm
You're welcome 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 10, 2012 at 11:23 am
n00bDBA (10/10/2012)
Do you know if osql was running all the scripts at the same time or it does one then proceeds to the next.
Separate calls to the exe will constitute...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 10, 2012 at 7:51 am
Chances are the issue has nothing to do with osql but I am compelled to say it anyway, switch to using sqlcmd.exe, osql.exe has been a deprecated feature since SQL...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 10, 2012 at 6:07 am
An examination of bulk-logged recovery model By Gail Shaw, 2012/05/07[/url]
If you have specific questions ask them here or post a new thread. Gail answers a lot of questions on these...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 10, 2012 at 5:59 am
Have you isolated what times the log grows to determin what is making it grow? If not, you can get this information from the Default Trace. Chart the trend when...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 10, 2012 at 5:14 am
Just because you slap a .xls extension onto a file does not make it an Excel-format file. What you have is a CSV (Comma-Separated Value) file saved with a .xls...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 10, 2012 at 5:04 am
As was stated all queries have an Execution Plan. Generating an Estimated Execution Plan for a query is one of the steps the Database Engine must do for all queries....
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 10, 2012 at 4:57 am
Viewing 15 posts - 2,896 through 2,910 (of 7,164 total)