Viewing 15 posts - 991 through 1,005 (of 1,079 total)
praveen640 (1/11/2010)
Thanku Mr Henrico Bekker but i want a duplicate database with same nameis there any way pls pls help me
Let me get this... You want the same DB...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 11, 2010 at 5:50 am
Backup the original, and restore with a different name.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 11, 2010 at 12:58 am
'Error 30 installing Microsoft SQL Server 2005 Setup Support Files See log file for detailed information.
The system cannot read from the sepecified device.'
What does your error log show?
There...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 4, 2010 at 12:21 am
Hi, read up on it first:
http://www.lazydba.com/sql/1__1624.html
http://sql-server-performance.com/Community/forums/p/4085/27763.aspx#27763
http://www.principiaprogramatica.com/?p=5
Basically, you are querying between 2 different instances, or 2 different SQL servers.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 3, 2010 at 11:17 pm
http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx
http://blogs.msdn.com/menzos/archive/2008/06/25/table-partitioning-in-sql-2008.aspx
http://sqlfool.com/2008/11/102/
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 17, 2009 at 10:11 pm
http://msdn.microsoft.com/en-us/library/ms979196.aspx
http://www.sql-server-performance.com/
and the list can go 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
December 14, 2009 at 5:18 am
KB refers to Knowledge Base - http://www.microsoft.com/protect/computer/updates/bulletins/number.mspx
MSDE refers to Microsoft SQL Server Desktop Engine - http://en.wikipedia.org/wiki/MSDE
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 14, 2009 at 5:14 am
http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1282913,00.html
http://msdn.microsoft.com/en-us/library/ms141026.aspx
Your question cannot be answered in one sentence..except one long sentence.
Read up on some of the above links..
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 14, 2009 at 12:59 am
Schedule Enabled?
Step in job enabled?
Job Enabled?
SQL Agent running?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 11, 2009 at 5:59 am
Thank you.
Well, firstly, NO BRAINDUMPS - they wont help you. You dont learn anything from them.
I used BOL alot, realy, alot.
The Real MCTS 70-432 Exam Guide - that book 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
December 10, 2009 at 10:18 pm
Microsoft decided to change this part in 2k8.
Right Click on your instance, and you'll find "Activity Monitor" in the list.
use the "Resource Waits" drop down (may I say tab?)
alternatively, just...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 10, 2009 at 10:09 pm
Taken from: http://technet.microsoft.com/en-us/library/cc966534.aspx
Best practises suggest you:
Consider configuration of TEMPDB database
Make sure to move TEMPDB to adequate storage and pre-size after installing SQL Server.
Performance may benefit if TEMPDB is placed...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 10, 2009 at 5:41 am
Remember - sheat sheets and quick fix info will only get you so far.
Rather invest in the books suggested, and familiarise yourself.
This will also make you more confident in your...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 3, 2009 at 9:58 pm
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
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?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 1, 2009 at 9:19 pm
Viewing 15 posts - 991 through 1,005 (of 1,079 total)