Viewing 15 posts - 1,006 through 1,020 (of 1,079 total)
I believe everything you need can be logged via counters in perfmon.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 27, 2009 at 1:50 am
Thanx Dave, never too old to learn something new 🙂
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 27, 2009 at 1:41 am
definitely with bcp utility, and a query inside....
C:\>bcp "select top 50 * from DatabaseName.dbo.Table_Name" queryout Test.bak -U username -P password -c -t
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 26, 2009 at 11:27 pm
use Rand() as [your values here or reference]
example:
SELECT CAST(RAND() * 1000000 AS INT) AS [RandomNumber]
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 26, 2009 at 11:14 pm
Thank you for all the insightfull replies.
Seeing that we all agree more or less on the subject, I am putting this in my manual as "Best Practice" 🙂
No disrespect 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
November 26, 2009 at 12:19 am
http://www.sqlservercentral.com/articles/1324/
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 24, 2009 at 10:33 pm
http://www.sqlservercentral.com/articles/1324/
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 24, 2009 at 10:32 pm
"Microsoft® SQL Azure™ Database is a cloud-based relational database service built on SQL Server® technologies. It provides a highly available, scalable, multi-tenant database service hosted by Microsoft in the cloud....
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 24, 2009 at 1:44 am
yes, recently i have taken full database backup and i missed .mdf file,how to recover it?
and one more
how to recover the accidently deleted job by one of the user?
can 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
November 23, 2009 at 12:49 am
Try RedGate SQL ToolBelt
and (SSC gonna hate me) Idera SQL Diagnostics Manager
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 22, 2009 at 11:17 pm
We run an ancient VB6 based app, and level 80 DB on SQL 2005 STD.
Someone enabled automatic updates on all servers, and the patches ans SP's came in from hell...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 22, 2009 at 11:15 pm
Hi, please provide more detail?
which database? system? which file? mdf, ldf? etc....
any backups made recently?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 22, 2009 at 11:11 pm
We have one 37 million table having 20 + columns with all the person information, But almost, 7 million records having duplicate emails
But other fields are different.
Insert into New
select *...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 20, 2009 at 2:59 am
You mean you dont have permission, to grant permissions to others?
have your DBA grant sysadmin rights...where and if needed.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 20, 2009 at 2:49 am
to continue with what Steve suggested....
If 3rd Party tools are not available, build your own and very accurate health check system with perfmon.
include the SQL counters for growth, fragmentation, backups,...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 20, 2009 at 1:49 am
Viewing 15 posts - 1,006 through 1,020 (of 1,079 total)