Viewing 15 posts - 1,036 through 1,050 (of 1,079 total)
Let me start of with saying, it's not important, it's critical.
Managing db's, with odd proc's running against them, is not a task I want to spend my full day on.
I...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 9, 2009 at 9:53 pm
V1 i2, as you SQL instances are hosted on the virtual servers and not your physical.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 2, 2009 at 9:39 pm
Windows or SQL Autentication in the ODBC setup?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 29, 2009 at 12:57 am
p.ramchander (9/22/2009)
i am in a process of creating a job to export data from database to excel sheet using ssis package... but when i am trying to run the job...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 22, 2009 at 5:55 am
http://www.tizag.com/mysqlTutorial/
http://dev.mysql.com/doc/refman/5.0/en/tutorial.html
http://www.devshed.com/c/b/MySQL/
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 22, 2009 at 5:54 am
(Please correct me if I am wrong) but I am almost sure those are the only options, I have Server Storage as a option as well, but doubt if it...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 22, 2009 at 4:53 am
hope it helps, i know it is not ideal.
play with it.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 22, 2009 at 2:16 am
mak3 (9/22/2009)
error, warn, kill, dead, cannot, could, fail, not, stop, terminate, bypass,...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 22, 2009 at 2:14 am
assigning a temp datafile, to each core (given they were created correctly, all the same size) will avoid contention for the main tempdb usage, major increase in performance.
There is...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 21, 2009 at 10:42 pm
Silverfox (9/21/2009)
Henrico Bekker (9/21/2009)
Narendra-587652 (9/21/2009)
i have 500 server and differnt version of SQl(2000,2005,2008) and have to
find SQL client or SQL server...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 21, 2009 at 7:15 am
Narendra-587652 (9/21/2009)
i have 500 server and differnt version of SQl(2000,2005,2008) and have to
find SQL client or SQL server installed on these...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 21, 2009 at 7:01 am
george.frewin (9/21/2009)
I am running SQL Server 2005 and when i run large queries i find that i am losing significant amounts of hard drive space very quickly (about 7gb)...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 21, 2009 at 6:51 am
I must agree with "90% of what?"
but:
Backup Log db_name with Truncate_only --(clear it without deleting it)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 21, 2009 at 6:47 am
Narendra-587652 (9/21/2009)
Hithank's for reply
can i know about (Client or Server) of a machine by seeing 'Add or Remove Programs'
If you chose "Client Tools Only" in the setup...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 21, 2009 at 6:42 am
mchou (9/21/2009)
Does dynamic AWE add additional overhead to SQL Server?
Which version are you running?
running 64 bit wont have an influence.
running 32 bit and more than 16gb ram yes.
Please supply more...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 21, 2009 at 6:33 am
Viewing 15 posts - 1,036 through 1,050 (of 1,079 total)