Viewing 15 posts - 2,896 through 2,910 (of 7,168 total)
I agree with Andy. What you have now is what I call the 'spreadsheet approach' to data modeling where everything is in one wide table. You said one column can...
October 21, 2012 at 11:21 am
You should see an entry in the SQL Server Error Log when an integrated connection fails (as long as you're still logging failed login attempts). The error number, severity and...
October 21, 2012 at 10:58 am
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...
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...
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...
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...
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,...
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.
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...
October 11, 2012 at 8:46 am
steveo1967 (10/10/2012)
October 10, 2012 at 7:41 pm
You're welcome 🙂
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...
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...
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...
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...
October 10, 2012 at 5:14 am
Viewing 15 posts - 2,896 through 2,910 (of 7,168 total)