Viewing 15 posts - 136 through 150 (of 534 total)
I agree about Database collation usually being sufficient... but we fought with the vendor because they wanted us to change the TEMPDB collation when we set them up in...
February 2, 2011 at 11:54 am
Default instance for most applications, one infrastructure monitoring app that has it's own instance for permformance tuning reasons and two other instances for applications that need a certain or custom...
February 1, 2011 at 10:44 am
we had fully intended on making it a true 64 bit installation. did all of the installs and scheduled application testing.. most of which is completed -...
February 1, 2011 at 10:23 am
we are in the midst of retiring an older server (32bit) to a new Server (64bit)
We have one application (for our legal department) that has it's own instance...
February 1, 2011 at 8:57 am
Thank you so much for your replies. my only real concern is mixing 32bit and 64bit instances on the same box. Sounds like...
February 1, 2011 at 7:17 am
Any thoughts on mixing the instances? in other words, uninstall one of my named instances and reinstall it using the SQL Server 2005 32bit software and leaving the...
January 31, 2011 at 7:31 am
Thanks for all your help!!!
January 27, 2011 at 4:31 am
I am not the Developer. I take care of the Server that hosts their SQL Server Database and attempt to act as DBA for them. ...
January 26, 2011 at 4:00 pm
not sure what snarky means.. but you are right.. I could do with some training .. time to hit the books!
turns out that they are...
January 26, 2011 at 2:11 pm
I apologize for the different row counts.. I have different versions of the same table (DEV, Stage, Prod) Prod has the 19,000+ rows
the table in PROD is 3,155.422 MB
I ran...
January 26, 2011 at 11:53 am
When logged into the Server - the response time is the same doing a simple Select * from Forms_Holder - 4 mins to return 19000 rows
but the wait...
January 26, 2011 at 11:20 am
no triggers and this is the only table that is displaying this behaviour.
copied the table to another instance and am getting the same results. 4 minutes to return...
January 26, 2011 at 11:00 am
The delete was against a dev box.. I wouldn't delete in Stage or Production without first finding out why.... which is why I started asking...
January 26, 2011 at 10:36 am
Thank you!! I changed my query to
DELETE FROM forms_holder
WHERE rec_date <= DateAdd(d,-365,GETDate())
related (I think) question. I questioned the developer as to why he wanted the...
January 26, 2011 at 10:12 am
select * FROM forms_holder
WHERE rec_date <= DateAdd("d",-365,Date())
the error I get is 'Date' is not a recognized built-in function name.
January 26, 2011 at 8:48 am
Viewing 15 posts - 136 through 150 (of 534 total)