Viewing 15 posts - 2,926 through 2,940 (of 7,164 total)
PiMané (10/8/2012)
But CustomerCode is not sequential and can generate a lot of fragmentation on the clustered index.
That might be OK. If you set your fill factor appropriately you can fend...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 3:05 pm
PiMané (10/8/2012)
opc.three (10/8/2012)
How wide is that customerCode and is that an oft-used column to increase selectivity?
Pardon my ignorance, not used to some technical terms in English, but what do...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 2:58 pm
The attachment didn't appear to make it. Did you click the "Upload Attachments" button after choosing your file(s)?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 2:55 pm
So the question really is:
How do I estimate the size of my FULL backups so I can predict when I should add another backup device? :Whistling:
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 2:53 pm
arussell_10 (10/5/2012)
The development group at my new company is using a WCF service running on the SQL Server to call a stored procedure that executes xp_cmdshell to call an SSIS...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 2:47 pm
PiMané (10/6/2012)
I'm reviewing our database tables and found some "bad" practices like Clustered index with Uniqueidentifier columns using NewId - support for SQL2005 is mandatory.
I was woundering, and already have...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 2:26 pm
No, it won't hurt a thing to disable 1204.
Do you know how they were enabled? If not then check the startup options of the instance. If they were enabled using...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 2:18 pm
antonio.collins (10/8/2012)
a trigger can be written so it is only fired if some column(s) of interest are set/modified.
Not entirely true. A trigger fires for every qualifying DML action. For INSERT...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 2:04 pm
GSquared (10/8/2012)
The better solution would be rebuild the database and normalize it standardly.
+1
You do have a path to refactor the database and not change a line of VB6 code. It...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 1:59 pm
LOG, FULL or DIFF?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 1:55 pm
This article is a good primer on the different options and still applies to current versions of .NET:
How to implement impersonation in an ASP.NET application
I think you're asking for the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 1:52 pm
Hit Reply to this post and then scroll down, look for the Edit Attachments button.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 1:44 pm
You posted in a 2008 forum but it looks like from the title of your post you're on 2005.
Here is a link on how to connect to a SQL 2005...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 1:43 pm
blakmk (10/8/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 12:45 pm
My gut says no, the transaction would not be committed until the OUTPUT clause completed being consumed by the caller. It is easy enough to test...
-- setup the environment
USE AdventureWorks2008R2
CREATE...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 12:13 pm
Viewing 15 posts - 2,926 through 2,940 (of 7,164 total)