Viewing 15 posts - 2,926 through 2,940 (of 7,167 total)
kingrudedog (10/8/2012)
I want to say:
(automatically) estimate the backup size of this database and split it up so that each backup portion is never bigger than...
October 8, 2012 at 3:21 pm
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...
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...
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)?
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:
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...
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...
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...
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...
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...
October 8, 2012 at 1:59 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...
October 8, 2012 at 1:52 pm
Hit Reply to this post and then scroll down, look for the Edit Attachments button.
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...
October 8, 2012 at 1:43 pm
blakmk (10/8/2012)
October 8, 2012 at 12:45 pm
Viewing 15 posts - 2,926 through 2,940 (of 7,167 total)