Viewing 15 posts - 4,201 through 4,215 (of 7,164 total)
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 3, 2012 at 6:16 am
DBA_SQL (5/2/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 2, 2012 at 10:05 pm
Evil Kraig F (5/2/2012)
sqlbi.vvamsi (5/2/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 2, 2012 at 8:09 pm
How much data are we talking total across the 15 tables?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 2, 2012 at 7:25 am
kwoznica (5/1/2012)
thanks OPC I'm going to put this on my test server now. I'll let you know how it turns out.
I tested it locally on a 2008R2 instance. Please post...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 1, 2012 at 3:48 pm
Ronnie Jones (5/1/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 1, 2012 at 2:53 pm
Viewing 15 posts - 4,201 through 4,215 (of 7,164 total)