Viewing 15 posts - 7,546 through 7,560 (of 9,244 total)
First identify the column(s) that comtain the pertinent data. Once identified the following will suffice!
Select TOP 10 column, column, ...
From mytable
Order by somecolumn desc
October 18, 2010 at 5:32 am
Not all SQL servers are suitable virtualisation candidates!
October 18, 2010 at 12:34 am
the question displays a degree of ambiguity but not stupidity!
October 17, 2010 at 2:03 pm
please do not double post, you already have a thread on this subject in the appropriate forum.
Replies to http://www.sqlservercentral.com/Forums/Topic1005872-1549-1.aspx
October 17, 2010 at 1:36 pm
do you have a separate computer or are you installing your mirror instance on the same machine as the principal?
October 17, 2010 at 12:16 pm
Steve Jones - SSC Editor (10/16/2010)
Of course, that limits the size of the host, and then the VMs
This, I suspect, is the key here!
October 16, 2010 at 8:28 am
Jeffrey Williams-493691 (10/15/2010)
timscronin (10/15/2010)
if the log is growing that large because you are rebuilding all of your indexes every night
as a side note, if you rebuild indexes in simple recovery...
October 16, 2010 at 7:55 am
daveb87 (10/15/2010)
I think it is a good practice to backup the Master, MSDB and Model databases on a regular basis.
It's vitally important!!
daveb87 (10/15/2010)
October 16, 2010 at 7:14 am
Not much to say here that's not already been said really!
My own experiences are with various systems including Shabba's environment where i worked on the design\deployment.
This has to be...
October 16, 2010 at 7:01 am
I'm with Gail on this WHY???
Having said that, to delete a row without using DELETE simply requires an UPDATE which nullifies any column data. OK the row isn't actually deleted,...
October 16, 2010 at 5:37 am
Geoff A (10/15/2010)
make sure the SQL Server Browser service is running.
This is not required when specifying the ip address and port!
October 15, 2010 at 6:55 am
Regardless, you would be well advised to backup all system databases as a set. If you ever had to restore you would certainly want MSDB and Master to be in...
October 15, 2010 at 3:26 am
In SQL Server 2008 the only system database moved to a cluster node local drive (the SQL Binn directory) is the MSSQLSystemResource database. This is to facilitate, as far as...
October 15, 2010 at 3:15 am
Hmm looks correct, that's the format I use
192.X.X.X,port
Have you set a static tcp port for the named instance or is it still set to dynamic?
Also have you checked the event...
October 15, 2010 at 12:25 am
Yes and how are you specifying the IP and port number, what are you typing into the connection dialog box?
October 14, 2010 at 1:55 pm
Viewing 15 posts - 7,546 through 7,560 (of 9,244 total)