Viewing 15 posts - 736 through 750 (of 1,079 total)
I really don't think it's such a major transition, there are a few extra features, discontinued features, but the biggest difference in versions are in BI.
Do the training to get...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 1, 2010 at 1:51 am
SHUTDOWN WITH NOWAIT
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 1, 2010 at 1:35 am
dy265 (6/30/2010)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 30, 2010 at 7:09 am
venkatb.dba (6/30/2010)
Hi,when i am finding server health i can't able to understand how we check that
how can we monitor the general health of the server?
Server, or SQL Server?
You can...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 30, 2010 at 5:26 am
This is an undocumented script like SP_MSForEachTable...
Try:
exec sp_msforeachdb @command1='ALTER DATABASE ? SET AUTO_UPDATE_STATISTICS ON'
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 29, 2010 at 11:29 pm
Good tricky one...thank you
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 29, 2010 at 11:14 pm
I agree Steve, that 2nd England goal should have been awarded...but overall, the German's were much better.
England's defense was non existent, attacking lacked aggression.....
Basically, Germany still outplayed them.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 27, 2010 at 11:12 pm
Yes, definitely a good career choice.
MS SQL will always be in demand, it's an excellent product, easy to manage, and capable of doing great things. (no, MS didn't pay me...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 25, 2010 at 12:47 am
Here is a good script...credits to the authors...
/****************************************************************************************
NAME:DATABASE I/O STATISTICS
BY:MARK JONES
DATE:19-02-2008
PURPOSE: Provides useful statistics about Database I/O requests. Uses the function
::fn_virtualfilestats to retreieve all the database file statistics includeing
...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 24, 2010 at 1:22 am
SQL will allocate as much memory as needed/available.
Configure your maximum memory allocation within SQL, leaving adequate memory for the OS and other services.
On a 16gb server, I'd configure SQL to...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 24, 2010 at 12:40 am
The job is being run as the zz_sql_dhsx account which is a member of the sysadmin role.
on both sides? (source & destination?)
You still didn't provide any sort of error messages...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 23, 2010 at 1:44 am
Schadenfreude-Mei (6/23/2010)
CirquedeSQLeil (6/22/2010)
GilaMonster (6/22/2010)
Steve Jones - Editor (6/22/2010)
Sorry, Gail, looks like SA is not moving on in the World Cup.🙁
What a surprise. Not.
At least we didn't lose every match...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 23, 2010 at 1:41 am
At which sort of step are your packages failing?
Using any authentication within these specific packages?
As what are you running these packages under the agent?
Error messages?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 23, 2010 at 1:37 am
You just brought up something I think most people forget, that we as humans still have the power over computers.
It's a 50/50 thing, we need the speed, they need our...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 23, 2010 at 12:37 am
I don't really think the poster would consider staying on SSC if he saw your post regarding his question, do you?
Even though this forum is maybe for blowing off steam,...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 22, 2010 at 5:09 am
Viewing 15 posts - 736 through 750 (of 1,079 total)