Viewing 15 posts - 4,201 through 4,215 (of 7,168 total)
...looking again...
May 3, 2012 at 1:20 pm
Elliott Whitlow (5/3/2012)
I agree there IS some complexity BUT it isn't really all that complex. There are some great how-tos and even BOL does a really good job.
Straight queueing...
May 3, 2012 at 1:11 pm
SQL Kiwi (5/2/2012)
opc.three (5/2/2012)
Elliott Whitlow (5/2/2012)
But like most things SQL, it depends.
From what has been shared so far the use case presents itself squarely in SB's wheelhouse, but I will...
May 3, 2012 at 10:13 am
Using the Excel Object Model is what I would do. I suspect that's what Craig (mentioned VBA, don't think he meant true Office Automation) and Revenant (Excel interop) are saying...
May 3, 2012 at 6:16 am
DBA_SQL (5/2/2012)
May 2, 2012 at 10:11 pm
I got you, I was just pointing out that the always-running polling option has downsides, as does the polling option where the proc exits, as does SB. My original comment...
May 2, 2012 at 10:05 pm
Evil Kraig F (5/2/2012)
sqlbi.vvamsi (5/2/2012)
May 2, 2012 at 8:09 pm
How much data are we talking total across the 15 tables?
May 2, 2012 at 8:05 pm
To edit other people's job you have to be part of the sysadmin Role. What you might do is create a new login and add it to the sysadmin Role,...
May 2, 2012 at 7:55 pm
HUGE topic that will completely depend on your system.
Here is a good source of information to help you: Comprehensive tempdb blog post series
May 2, 2012 at 7:40 pm
DBA_SQL (5/2/2012)
We know that in SQL Server, it is not possible to restore a backup copy of database from higher version(2008) to lower...
May 2, 2012 at 7:22 pm
Elliott Whitlow (5/2/2012)
SQL Kiwi (5/2/2012)
Elliott Whitlow (5/2/2012)
When you have to run that job every 1 minute or every 5 I'm thinking that method is less effective.
Perhaps. I think the...
May 2, 2012 at 12:15 pm
Elliott Whitlow (5/2/2012)
But like most things SQL, it depends.
From what has been shared so far the use case presents itself squarely in SB's wheelhouse, but I will leave it there,...
May 2, 2012 at 9:13 am
Wildcat (5/1/2012)
If no parameter after sp_updatestats, it will update ALL the stats within that database.
sp_updatestats will evaluate each stat, but only update those that it deems necessary based on how...
May 2, 2012 at 7:28 am
anonymous2009 (5/1/2012)
When a new index is added to an existing table with rows in it, is it always required to execute the following to update the stats (or) will Create...
May 2, 2012 at 7:25 am
Viewing 15 posts - 4,201 through 4,215 (of 7,168 total)