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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 5:32 am
Not all SQL servers are suitable virtualisation candidates!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 12:34 am
the question displays a degree of ambiguity but not stupidity!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2010 at 1:55 pm
Viewing 15 posts - 7,546 through 7,560 (of 9,244 total)