Viewing 15 posts - 5,386 through 5,400 (of 7,506 total)
you can offcourse always put the db in singleuser mode within the restore-batch.
use master
alter database yourdb set single_user with rollback immediate;
restore database your db
from ......
raiserror ('DBA- Restore Notification:...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 28, 2007 at 2:06 am
as far as I know that is not possible.
You'll have to restart from your fullbackup and keep it in Norecovery until you decide to use recovery.
At that time it will...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 28, 2007 at 1:56 am
We use acursor driven proc but just altering it to be #temptbl oriented, you might handle it like this:
DECLARE @SQLStatement nvarchar(4000)
--DECLARE TableList CURSOR LOCAL FAST_FORWARD READ_ONLY FOR
Declare @tmpReindexList table...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 28, 2007 at 1:20 am
Best practise is to always map your procedure parameters.
Otherwise parameterse are mapped according to their position in the parameterlist in the exec-clause.
Also keep in mind when using e.g. a vb.net...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 28, 2007 at 1:00 am
if you need order, then you'll have to tell it to the system.
So add and "Predicate_order" column so you can sort your select set according to it.
If you need rows...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 27, 2007 at 8:20 am
most of the time just restarting the sqlserver service will solve your problem. (depending on the number of operations it needs to rollback)
Reason: at startuptime of a db, all uncomplete...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 27, 2007 at 8:07 am
your statement
ALTER AUTHORIZATION ON consultant.DimConsultantStatus TO dbo;
just tells the system the object consultant.dimconsultantstatus is owned by dbo.
you should use
ALTER SCHEMA dbo TRANSFER consultant.DimConsultantStatus;
GO
Check bol.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 27, 2007 at 8:03 am
Since the title is "where to start" ...
Start using aliasses everywhere to avoid confusion.
(occurs especialy after query maintenance !)
select name
from table1 a
where not exists(select 1 from table2 T2...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 27, 2007 at 1:28 am
varun-jha (12/24/2007)
on any databases so how i can get the infornation when the table you specified in the code...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 25, 2007 at 8:17 am
I wouldn't advise to tamper with it, but you might want to script proc [sys].[sp_settriggerorder]
SELECT *
FROM sys.triggers
WHERE parent_ID = OBJECT_ID('HumanResources.Employee')
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 24, 2007 at 8:25 am
SQLExpress will at most use 1 Gb of ram
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
- did you perform full dbmaintenance after setup ?
(dbcc dbreindex , sp_updatestats, dbcc updateusage)
- -- checkdb with content-re-eveluation
DBCC CHECKDB (0)...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 24, 2007 at 6:47 am
The log-file can only shrink until the last log-chunck in use.
You'll force it to shrink manualy.
http://support.microsoft.com/kb/q256650/ is for sql7, but also works on sql2000
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 24, 2007 at 6:17 am
the refs will clarify it in detail, but ...
- in short a schema is nothing else than a logical rack for objects.
All objects must be member of one...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 24, 2007 at 5:46 am
if you want to completely get rid or the usage of the identity property, you'll have to generate drop/create table statements !!
Keep in mind, that there is a purpose for...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 24, 2007 at 1:30 am
- There shouldn't be an order-dependency in the triggers !!
- sp_settriggerorder allows you to set the First and Last trigger.
(check BOL)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
December 24, 2007 at 1:00 am
Viewing 15 posts - 5,386 through 5,400 (of 7,506 total)