Forum Replies Created
Viewing 15 posts - 6,376 through 6,390 (of 7,505 total)
-
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
-
RE: DRI or No DRI?
This is the same debatecontext like for NULLs.
OK, DRI is a pain in the but for developers, but it guarantees some data related...
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
in addition to PW 's reply ...
is the create table for the temptb also within this transaction ?
I've read about this situation...
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: Why are the sizes so different?
how recent are your statistics ?
run sp_updatestats and dbcc updateusage ('yourdb') with count_rows.
This may interfere with ongoing operations !
Then check your...
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: hostname doesn''''t match MAC Address (net_address)
just a wilde shot ...
The hostname is determinde by data from the connection string.
What's the application name that's shown ?
In case of excell...
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 SHOWCONTIG drives DBREINDEX
It might make sence to run sp_updatestats and dbcc updateusage(0) with count_rows manualy. This may interfere with ongoing operations !
Then try your procedure again
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 Name differnt to Computer Name
If your applications connect using the IP-address
there will be no problem.just be sure to follow this: http://www.databasejournal.com/scripts/article.php/1496451
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: Create Index on Network drive
just my 2ct.
in addition to PW's and Strommy 's replies :
Your cluster-instance must have the new...
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: Parsing a comma delimited string into multiple rows---Please Help!!!
take a look at http://www.sqlservercentral.com/scripts/contributions/592.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: Stored Procedure to Map a drive
imo if you allocate a drive letter (net use z) , you should also unallocate it (net use z /delete).
Unless offcourse this is an action that would be performed very often.
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
Viewing 15 posts - 6,376 through 6,390 (of 7,505 total)