Viewing 15 posts - 556 through 570 (of 1,079 total)
If you are willing to cover my immigration, moving and housing costs from South Africa, I'll come work in Chicago 😛
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 18, 2011 at 10:21 pm
What is up with all the spam threads?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 17, 2011 at 1:34 am
The average usage of RAM by both instances is about 20GB for instanceA and about 10GB for instanceB, but both instances have at some point taken > 30GB so 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
January 13, 2011 at 2:45 am
press Control+Left Shift+ F
This sets your SSMS output to File.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 12, 2011 at 6:03 am
sql_butterfly (1/12/2011)
No No. I just need one record per Team Id. The one with latest Orderdate. Consider there are lots of Teams with hundrds of OrderDates.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 12, 2011 at 1:01 am
I need to write a wuery which can give the result:
TeamId OrderDate Value
--------------------------------
A1 2010-11-10 5000.00
A2 2010-11-09 1100.00
(I mean TeamId wise the latest order)
SELECT DISTINCT TeamId, OrderDate, Value from yourtable
ORDER by...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 12, 2011 at 12:16 am
Well as i said full backup of the database is taken daily, my concern is if i take transactional log backup monthly will it contain all the transactions from previous...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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, 2011 at 10:28 pm
I'd recommend installing the DTC before installing SQL Server.
Herewith some information you can read up on...
http://blogs.msdn.com/b/sqlblog/archive/2006/10/06/msdtc-and-sql-server-on-a-cluster.aspx
http://support.microsoft.com/kb/254321
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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, 2011 at 10:23 pm
No.
UCP is for 2k8 R2 systems.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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, 2011 at 10:18 pm
Looks like a generic connection string copied from http://www.connectionstring.com.
You need to modify the servername, userid, password etc.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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, 2011 at 10:15 pm
Roxette - The big love
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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, 2011 at 10:12 pm
sudeepta nanda-402098 (1/11/2011)
A database is very large how to take full backup of the database.
How "large" is "very large" ?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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, 2011 at 2:07 am
GilaMonster (1/11/2011)
Henrico Bekker (1/11/2011)
If your source SQL Server is on a newer Service Pack level, your destination needs to be the same.
You can, in the vast majority of cases, restore...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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, 2011 at 12:56 am
Can i restore the prod db backup (SQL 2000 Ent) to Dev Box ( SQL 2000 Std).
If both SQL Servers are on the same level version, yes.
If your source SQL...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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, 2011 at 12:24 am
you can only recover back to the last data that you backed up.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 10, 2011 at 11:44 pm
Viewing 15 posts - 556 through 570 (of 1,079 total)