Viewing 15 posts - 556 through 570 (of 1,081 total)
Easy one...but have to admit, made me think a bit..good one, thank you.
January 19, 2011 at 11:46 pm
Rather than joining rows, why not build a better table design?
January 18, 2011 at 10:23 pm
If you are willing to cover my immigration, moving and housing costs from South Africa, I'll come work in Chicago 😛
January 18, 2011 at 10:21 pm
What is up with all the spam threads?
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...
January 13, 2011 at 2:45 am
press Control+Left Shift+ F
This sets your SSMS output to File.
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.
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...
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...
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
January 11, 2011 at 10:23 pm
No.
UCP is for 2k8 R2 systems.
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.
January 11, 2011 at 10:15 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" ?
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...
January 11, 2011 at 12:56 am
Viewing 15 posts - 556 through 570 (of 1,081 total)