Forum Replies Created
Viewing 15 posts - 6,676 through 6,690 (of 7,502 total)
-
RE: maint plan degrade the perfmon
did you also perform sp_updatestats, dbcc updateusage and dbcc freeproccache (so newly generate plans come in).
Maybe it's time to use profiler to capture load and analyze it to check if...
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: dbo, who should it be?
imo the only difference for the "dbo-login" is that (s)he does not have to qualify schema DBO when creating objects. Members of the db-owner db-group always have to specify the...
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: following info about all the dbs on the server at one go
This is how I'd solve it : (be aware of collation conflicts !)
print 'Fillocations of DB'
print '------------------'
declare @SelStmt as varchar(7000)
declare @DbNaam as varchar(125)
declare...
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: SQLPutData
yep, basic rule No 1 for programming is still : "learn copy/paste"
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: SQL logins changed domains
That should be no problem because the new domain will use the old sid from the users sid-history.
The only "issue" you'll have is...
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: help creating sequence value using sql transaction
... parameter-table and proc set to manage sequences ...
This way you could emulate identity
This is just a simple representation :
create table t_mySequenceParameters (
TableName...
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: SQL logins changed domains
you could add the old domain's user-SID to the new domain-user's sid-history.
As you can imagine, this is a windows-ad-operation, and not a sqlserver operation....
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: help creating sequence value using sql transaction
you may want to check out IDENTITY and scope_identity if you can live with gaps in your numberings.
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: The maximun Power of a Database
we always set it to the max available blocksize
and let sql handle it internaly.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: SQLPutData
Can't DTS help ?
(check out Enterprise manager, database, tables, rightclick and choose import data. The wizard
will guide 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: Hekp - Deleting Table/Records
In addition to sa24's advice, you can also use this delete-batch.It will take a while, but since transaction are kept small, interferance should...
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: use of trigger to update history table
CREATE TRIGGER Itr_T_CurrentON T_CurrentFOR INSERTASinsert into T_History select * from insertedGO
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: Memory Allocation
maybe these resources can help :
- http://www.sqlservercentral.com/columnists/jsack/aweadventures.asp
- http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;319942
- http://www.sql-server-performance.com/sql_server_performance_audit5.asp
- http://www.sql-server-performance.com/jc_sql_server_quantative_analysis7.asp
- http://www.sql-server-performance.com/awe_memory.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: List all tables and filenames for each
Keep in mind filegroup-files are balanced within a group, so your maxcapacity is the size of the smallest file * the number of files in the filegroup.
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: List all tables and filenames for each
Is this what you're looking for ?
this query uses native sqlserver systemtables .
SELECT FG.groupid AS GroupID
, SUBSTRING(FG.groupname,1,30) AS FilegroupName
, SUBSTRING(O.name,1,30) AS ObjectName
,...
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,676 through 6,690 (of 7,502 total)