Viewing 15 posts - 3,886 through 3,900 (of 7,506 total)
You may want to work with a delete loop of smaller chuncks of your data.
Keep in mind your logfile may grow during this operation.
I don't know where I got this...
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
March 23, 2009 at 7:17 am
For sqlserver I suggest you use the bigest allocation unit size your windows supports.
It will be the smallest unit of allocation for any file(extend) on that volume.
So the smaller it...
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
March 23, 2009 at 7:10 am
Thank you Jacob.
I'll give it a try.
Johan
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
March 23, 2009 at 1:37 am
Kaushalendra Singh (3/22/2009)
folowing this staps
open the notepad
copy
then save the text file at changespassord.bat in c...
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
March 22, 2009 at 6:16 am
Paul Randal (3/22/2009)
Because I wrote the code.
We don't hear that very often :w00t:
Thank you for the contribution and the urls.
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
March 22, 2009 at 6:11 am
keep in min to change the dblevel to 90 !!
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
March 21, 2009 at 8:38 am
Did you try to do it like this ?
Declare @ComputerNamePhysicalNetBIOS varchar(256)
Set @ComputerNamePhysicalNetBIOS = 'Server [' + @@servername + '] Running on - ' + Convert(varchar(128),SERVERPROPERTY('ComputerNamePhysicalNetBIOS') )
Declare @Subject varchar(256)
Select @Subject =...
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
March 20, 2009 at 1:22 pm
It took me a lot of frustrations but I got it to work :w00t:
-- ...
If object_id('tempdb..#LocalGroupMembers') IS NULL
begin
Create table #LocalGroupMembers ( IdNr int identity(1,1) not null
, [ServerName] varchar(128)...
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
March 20, 2009 at 7:36 am
Advantages ?
Mainly you save drive letters
and you can use more than 26 logical drives for a single instance of sqlserver
BP say for performance you would need:
- tempdb on a...
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
March 20, 2009 at 1:25 am
Thanks again 🙂
It gets quit confusing (sheer volume) to find the right corner in the maze to get started. :hehe:
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
March 20, 2009 at 1:08 am
Thank you for your help.
I keep on getting lost whenever xml is being used with cross apply.
How does it retain the correct parent/child dependency ?
I'll try to work on this...
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
March 19, 2009 at 2:48 pm
Nice article James :w00t:
Good overview towards the remarks and caveats.
We are using MPs for a while now (with sql2005) and didn't encouter any problems yet.
Knock on wood:Whistling:
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
March 19, 2009 at 2:33 am
SP3 = SP2 + cu9
SP3+CU1 = SP2+CU11 !
You can go directly to sp3 and then apply CU1 for sp3. (Current is CU2)
( http://support.microsoft.com/kb/960598/en-us )
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
March 19, 2009 at 1:02 am
rlondon (3/18/2009)
If you decide to set the database to single user mode, don't forget to set it back to multi user mode when finished.ALTER DATABASE [Database_Name] SET MULTI_USER
Keep in mind...
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
March 18, 2009 at 7:58 am
ronss (3/17/2009)
This is the error I get.Date03/17/2009 1:21:27 PM
LogSQL Server (Current - 03/17/2009 1:21:00 PM)
SourceLogon
Message
Login failed for user 'sa'. [CLIENT: 192.168.76.14]
and the client is the IP address of your sqlserver...
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
March 17, 2009 at 2:25 pm
Viewing 15 posts - 3,886 through 3,900 (of 7,506 total)