Viewing 15 posts - 1,006 through 1,020 (of 1,080 total)
Good question Steve. I’ll have to agree with you, today’s best is tomorrows second best.
Although we sometimes think we are on top of a problem, and the perfect solution, the...
December 1, 2009 at 9:28 pm
use AdventureWorks2008
go
select Name from HumanResources.Department
where ModifiedDate in (select ModifiedDate from HumanResources.EmployeePayHistory)
this is just an example if I understood your question correct?
December 1, 2009 at 9:19 pm
I believe everything you need can be logged via counters in perfmon.
November 27, 2009 at 1:50 am
Thanx Dave, never too old to learn something new 🙂
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
November 26, 2009 at 11:27 pm
use Rand() as [your values here or reference]
example:
SELECT CAST(RAND() * 1000000 AS INT) AS [RandomNumber]
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...
November 26, 2009 at 12:19 am
November 24, 2009 at 10:33 pm
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....
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...
November 23, 2009 at 12:49 am
Try RedGate SQL ToolBelt
and (SSC gonna hate me) Idera SQL Diagnostics Manager
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...
November 22, 2009 at 11:15 pm
Hi, please provide more detail?
which database? system? which file? mdf, ldf? etc....
any backups made recently?
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 *...
November 20, 2009 at 2:59 am
Viewing 15 posts - 1,006 through 1,020 (of 1,080 total)