Forum Replies Created
Viewing 15 posts - 5,956 through 5,970 (of 7,506 total)
-
RE: .NET application, timeout period elapsed
can you also post the query ?
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: .NET application, timeout period elapsed
- start sql-profiler to capture a sample load and examine it for table and or index scans.
- do you have db-maintenance-jobs in place ? to reduce fragmentation
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: Database Restore for SQL 2005 Enterprise...
- for the data-part the is no difference for 32 or 64-bit OS / SQLServer
- however if you are using the CLR, I guess it would be nice to avoid...
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: Triggers
- I wouldn't advise a trigger for this purpose ! (start job) because if the start job fails, your transaction fails !
- I woudn't advise a trigger for this purpose...
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: Optimizations job error message
this could be your test-script ....
print '00 Creating dbo.test';
go
create table dbo.Test (col1 int not null )
go
print '01 inserting rows into dbo.test';
go
insert into test values(1);
go
print '02 Selecting from unqualified table test';
go
select...
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: Error 21776: [SQL-DMO] The name ''''dbo'''' was not found in the Users collection
I guess that's what the "true" parameter is for in
use exec sp_changedbowner 'sa', true.
You can use sp_changeobjectowner @objname = 'oldowner.object' , @newowner = 'newowner'
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: How to query file name used for a particular backup?
making this #é&() mistakes, you can immagine the rest of my day
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: How to query file name used for a particular backup?
Still early on the day
SELECT BS.database_name
, BMF.physical_device_name
, BMF.device_type
FROM msdb.dbo.backupset BS
INNER JOIN msdb.dbo.backupfile BF
ON BF.backup_set_id = BS.backup_set_id
INNER JOIN msdb.dbo.backupmediafamily BMF
on BMF.media_set_id = BS.backup_set_id...
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: How to query file name used for a particular backup?
SELECT BS.database_name
, BF.physical_name
FROM msdb.dbo.backupset BS
INNER JOIN msdb.dbo.backupfile BF
ON BF.backup_set_id = BS.backup_set_id
WHERE BS.database_name = 'MyDB'
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: Optimizations job error message
- If you're using a "sqlserver maintenance plan", it will optimize _all_ objects of the selected databases.
- verify that they don't drop and recreate their tablesat runtime ! because then...
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: permission to access .BAK files for test restore
- your sqlserver-serviceaccount or your sqlagent's (if you're using a job) need read-auth for the .bak-file
- you as sql-user ... you need to be at least db-creator or database-owner...
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: Optimizations job error message
This is one of the enoying things where they use actual "work"-tables in stead of #-temp-tables.
So the create them on the fly, use them and drop the at the end...
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: Error 21776: [SQL-DMO] The name ''''dbo'''' was not found in the Users collection
use exec sp_changedbowner 'sa', true.
Keep in mind this is one of the flaws of EM. You'll have to disconnect an reconnect to see the correct results.
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: permission to access .BAK files for test restore
If you want to restore using EM, you'll need to have the backup-file(s) at the server itself.
If your bak-files are on a remote location, you can use e.g. QA and...
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: change name on server running SQL2000 and Biztalk
check http://www.databasejournal.com/scripts/article.php/1496451
to apply the rename of your windows server in your sqlserver instance.
According to my biztalk-admin changing the biztalksettings to connect to the new servername should be a peice...
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 - 5,956 through 5,970 (of 7,506 total)