Forum Replies Created
Viewing 15 posts - 6,556 through 6,570 (of 7,499 total)
-
RE: DBCC REINDEX makes the transaction log grow exponentially
Indexdefrag is also less blocking than dbreindex, but it doesn't do the same phisical thing.
We use Indexdefrag when our productionmill is active (24/7) and we use dbreindex during planed production maintenance...
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
-
RE: MS-SQL Profiler & ASP Update Code Mystery?
do you use transactions ?
if yes :
do you commit (data should be there) or rollback (no data will be there) the transaction
Do you...
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
-
RE: Single User Mode
What if you put it all in a single batch:
ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
go
DBCC CHECKDB ( 'dbName' ?? REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD )
WITH ALL_ERRORMSGS
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
-
RE: Single User Mode
are you the onlyone working on that issue ?
Check your db-status again ! (sp_helpdb)
When putting a db in single-user , I suggest...
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
-
RE: Querry Help
I cannot find anything tricky in the query, so I guess it's a data-problem.
It contains only INNER-joins. Are you sure the data always...
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
-
RE: DBCC REINDEX makes the transaction log grow exponentially
check the pros and cons:
Breaking your recovery model can have its consequences !
If I breake it, I go from FULL to BULK, but rarely to simple.
I have some databases of...
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
-
RE: Granting Execute permission to user by dbowner not working
aha, ownership-chaining-problems
Who didn't stumble into that.
It may also be e.g. the query is build dynamic or run dynamic
like
create proc owner1.myproc
as
set nocount...
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
-
RE: it is possible to take sql server2000 database backup on another machine''''s disc.
You can also make the backups using SQL-devices.
So from within you sql-backup-job you can see zip
, but your backup-device will point to an...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
-
RE: Who''''s going to PASS?
I'll be flying in on 24 sept.
Brussels - Chicago - Dallas
I hope to be awake by Monday morning
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
-
RE: Restore: Point in time
if I'm correct Log P.I. can do such action.
SQLServer itself cannot, unless you do a full restore to point in time.
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
-
RE: Deleting a user (owner)
also keep in mind this user can be databaseowner.
check out sp_changedbowner @loginame = 'sa' ,@map = 'true'
- http://www.sqlservercentral.com/scripts/contributions/1502.asp
- http://www.sqlservercentral.com/scripts/contributions/500.asp
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
-
RE: Restore: Point in time
- You just need sqlserver backups to be able to restore. The backup-history is just a help-set for EM to determine a gui for restore. You can restore on another...
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
-
RE: Defaulting to certain values
ooh it must have been realy early in the morning ....
this inline select performs only a sum, so no duplicates
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
-
RE: Defaulting to certain values
btw, suppose your in-line-select returns more than one result ?
Wich one to pick ?
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
-
RE: Defaulting to certain values
just a first idea, early in the morning :
SELECT @ProjectID, CSPD.EventID, E1.LeadTime
, isnull(( SELECT DATEADD( d, -SUM( E2.LeadTime ), @CustomerShipDate )
FROM CompanySeasonProductTemplate AS CSPD2, Event AS E2
...
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
Viewing 15 posts - 6,556 through 6,570 (of 7,499 total)