Forum Replies Created
Viewing 15 posts - 6,361 through 6,375 (of 7,499 total)
-
RE: suppressing osql column padding
or mess with ansi padding
declare @tb table (col1 int identity(1,1) primary key
, mychar10 char(10) not null default('a')
, myvarchar10 varchar(10) not null default('b') );
set...
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: Disk Trashing Server
aparently an I/O bottleneck
- What's your drive(s) config ?
Maybe this helps a bit : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=214046
(check the mentioned articles ! )
- http://www.sql-server-performance.com/performance_monitoring_tutor_part4.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: The system cannot ind the path specified.
did you change sqlserver service accounts ?
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: auto incremation
Indeed it says "Design Table"
(There is no identity-property on views ! ) Then select the column you want to autoincrement.
In the column...
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: Rename a Server
Don't delete your jobs, you will loose their history.
Here's 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
-
RE: SQL 2005 backward compatibility to v65?
AFAIK the only db-level for SQL2005 to support are 70, 80 and 90.
Try the SQL2005 Upgrade Advisor to check your database.
You may even want to download sqlserver 2005 express edition...
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: is a particular connection member of sysadmin
How about using EXEC master..xp_logininfo @acctname = 'youruseraccount',@option = 'all'
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: Week Number
let's just save time ....
In our company, Week no 1 is the week wich contains January 4-th.
I've implemented these UDFs :
Maybe this gets...
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 Server 2005 "Compatibility mode" between editions?
Maybe you could start with http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
I don't know if there is a "emulate standard edition" switch
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: auto incremation
make that column an identity column.
Enterprise manager\yourserver\yourdatabase\tables\yourtable rightclick and edit.
Select the column and add the identity property.
Litle remark. When you enable the identity, you're nolonger alowed to use that column...
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: Configuring Memory for SQL EE on Windows 2003 with 4GB
Don't use the AWE because you don't have > 8Gb RAM.
Adding the /3Gb is enough.
Check out http://www.sql-server-performance.com/sql_server_performance_audit5.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: is a particular connection member of sysadmin
declare @Serveradmin int
Select @Serveradmin = IS_SRVROLEMEMBER ( 'sysadmin')
print @Serveradmin
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: automatically notify when running on low harddisk space
if you want to do this using SQLServer you can use xp_fixeddrives to see how much space is left on each (local) drive.
Create table #tmpDrives (Drive char(1), MBFree int)
insert into...
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: Query Bogged Down, sp_who2 Shows Multiple Rows w/ same SPID
It's not exactly what I was searching for, but maybe I'll comeup with it later :
- http://www.sql-server-performance.com/reducing_locks.asp
- http://www.sql-server-performance.com/sf_block_prevention.asp
- http://support.microsoft.com/kb/q193095/
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: can I lower priority on threads in SQL Server 2005 (64 Bit)?
I was aware of the concept you had in mind
, but I don't think this is implemented in sql2005.I think Windows WLM...
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,361 through 6,375 (of 7,499 total)