Viewing 15 posts - 1,486 through 1,500 (of 2,462 total)
mirravi (8/4/2010)
Hi,I am performing a DB back up to a particular location
JHow ? through SSMS ? then my guess is it will taking backup at default backup folder ? other...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 9, 2010 at 2:03 am
"select *" command will fetch every thing from the given table.
select the "acual execution plan " option to see how sql optimizer is fetching data.means which index or which operator...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 9, 2010 at 12:38 am
30 is for char or varchar ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 9, 2010 at 12:17 am
Jeff Moden (8/5/2010)
use the quiirky update in this manner....
Any article link ??
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 5, 2010 at 9:50 pm
i loved this internal hidden casting in case of integer values
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 4, 2010 at 6:32 am
can we opt here MANUAL FAILOVER option ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 4, 2010 at 6:26 am
Brandie Tarvin (8/4/2010)
Not necessarily. It depends on if this other drive is only a logical drive or if it's actually a different physical drive.
yes..true ..i was also talking about...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 4, 2010 at 6:24 am
which catalog ? try this select * from sys.databases where name = 'new Db name'
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 4, 2010 at 3:53 am
Spliting file definitely helps you. but the question what makes you to decide this spliting ?
What kind of issues you are facing on tempdb side ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 4, 2010 at 3:51 am
Rather you should focus towards the TEmpdb maintenance.thats the way to maintain tempdb size.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 4, 2010 at 3:39 am
GilaMonster (8/3/2010)
Difference could be related to data volumes, stats that haven't been updated, difference in schema, etc.
Have you run the procedure from management studio...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 3, 2010 at 5:57 am
vatha.meba (8/3/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 3, 2010 at 4:25 am
vatha.meba (8/3/2010)
Earlier it use to take 1...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 3, 2010 at 3:30 am
James Tech (8/2/2010)
Steve Jones - Editor (8/2/2010)
How are you querying it? Same query? same permissions/user account?varchar(50) shouldn't be an issue in terms of size/type.
Yes it is the same...here is the...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 2, 2010 at 9:41 pm
vatha.meba (7/30/2010)
I have used management studio to insert into the table and it inserts.
On average how much time it took ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 2, 2010 at 5:18 am
Viewing 15 posts - 1,486 through 1,500 (of 2,462 total)