Viewing 15 posts - 1,441 through 1,455 (of 2,462 total)
removed
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 17, 2010 at 6:35 am
mirravi (8/17/2010)
If we take back up for other location then the path will replaces the old with current, which is not happening for one my users system.
select that path and...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 17, 2010 at 6:21 am
IS sys.dm_db_index_usage_stats not a DMV ?
actually , there is one column "last_user_update" which hwe are using to capture all the tables got any kind of insertion/updation/deletion on it.then we...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 17, 2010 at 6:08 am
it should work faster if it doesnt contain any heavy columns ( BLOB type). use can take "BATCH approach"
or looping.
refer this http://www.sqlservercentral.com/articles/Top/63301/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 17, 2010 at 5:35 am
i think sql doesn't care about the blanks ( 2 or 3 or 4 space) for both char or varchar.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 17, 2010 at 5:29 am
Anamika (8/16/2010)
The "IF EXISTS " statement deletes the new SP'.
I didnt get this statement is the post code so post complete code .
Additionally check the Sp name...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 17, 2010 at 4:19 am
Arjun Sivadasan (8/16/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 17, 2010 at 1:31 am
i would say before moving to conclusion that database is optimized at its best level. we should try few things.like
database settings.
network traffic on both servers.
data volume (same in your...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 16, 2010 at 6:23 am
balasach82 (8/16/2010)
The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time....
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 16, 2010 at 6:12 am
mdp11 (8/16/2010)
I think Pradeep is right.His script will not create backup at default location.
i tested it on my local machine and found the backup file on the path...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 16, 2010 at 1:48 am
Paul two question for you 🙂
first, why optimizer will get confused by rownumber ( it return bigint value) for int type output ?
Second, SELECT ...INTO approach is minimal logged...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 16, 2010 at 1:40 am
Arjun Sivadasan (8/16/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 16, 2010 at 1:36 am
Twinsoft SME (8/13/2010)
Beside the trace flag, I would also configure an alert to notify when this occurs so you could capture the issue.
in perfmon ??? any link/article where...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 16, 2010 at 1:25 am
Adiga (8/13/2010)
Ramji29 (8/13/2010)
BACKUP DATABASE yourdatabasename TO DISK='ActualPathOfBackupFileName.bak'This will create the backup at default location.
This will not create the backup file at default location. It depends on what is the value...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 16, 2010 at 1:24 am
@gail
1000 pages or 10000 pages ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 13, 2010 at 6:24 am
Viewing 15 posts - 1,441 through 1,455 (of 2,462 total)