Viewing 15 posts - 2,926 through 2,940 (of 7,168 total)
Thanks. For future posts you can make the picture appear in your post by using the Image icon above the text window. Copy the link of the uploade image, yours...
October 8, 2012 at 4:01 pm
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
Viewing 15 posts - 2,926 through 2,940 (of 7,168 total)