Forum Replies Created
Viewing 15 posts - 7,201 through 7,215 (of 7,498 total)
-
RE: REPLACE function help!
In your select statement you can use case when ACCT_NO LIKE '%|' then REPLACE(ACCT_NO,'|','~') else ACCT_NO 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 occuring during Restoring database
sp_who / sp_who2 might help to determine who blocks.
If you haven en open EM connection to the db and an open connection to the db using QA, there are 2...
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: preventing doubles to be entered, check for quite equal
this is a long shot, but maybe SOUNDEX may help you (language dependent). Check BOL
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: OSQL -L couldnt find a online SQL2k server
maybe those servers tcp\ip settings are being set to hide from the network ?
(EM\server-properties\network config\tcp-ip)
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: sP_cursoropen
- Which timeout has been set by the application ?
(and which do you use with QA)
- This is a result of an ADO-recordset.
Why use a recordset...
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 change the user name from dbo
adding to Steve's solution.
To avoid this, make this current user member of db_owners group and make an other user db owner (sp_changedbowner @loginame = 'yyy' ,@map = 'true'
). This way...
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: ADO holding SQL Connection Open, WHY?
connection pooling
this will keep the connection alive for a while (default 60sec ?) because apparently building a connection taks a lot of resources....
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: Take too long to shrink a huge database, HELP!!!!
EdVassie points to the right direction.
Here's more :
http://www.sqlservercentral.com/columnists/sjones/wheredoiwanttogotodayrichdatatypes.asp
http://www.sqlservercentral.com/columnists/lsmith/storingandretrievingbinarydatainsqlserver.asp
http://www.sql-server-performance.com/asp_sql_server.asp
http://www.sql-server-performance.com/q&a17.asp
http://www.sqlteam.com/item.asp?ItemID=986
http://msdn.microsoft.com/library/periodic/period98/image.htm
http://msdn.microsoft.com/library/periodic/period98/asp98b1.htm
http://msdn.microsoft.com/library/partbook/asp/binarydata.htm
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 returning last 13 weeks
I hope this gets you on track :
SELECT country_code
, sum(case when datepart(ww,TsCrea) = datepart(ww,dateadd(ww,-13,getdate())) then 1 else 0 end) as count_13
, sum(case when datepart(ww,TsCrea) = datepart(ww,dateadd(ww,-12,getdate())) then 1 else 0...
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: Take too long to shrink a huge database, HELP!!!!
in addition to the other replies:
- If you know you'll need 13,5 Gb why do you try to shrink to 4 Gb ?
This way sqlserver will have to allocate...
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: BUG Or What Am I Missing
an other 2ct.
The best things about nulls is you don't need to use them.
So only define null alowed when you need null, when it makes sence for your datamodel...
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: GETDATE -> only DATE needed
Actualy, I don't consider this to be nitpicking
Your comments do point to brainteaser issues, when one does not keep in mind 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
-
RE: Deleting LOG FILES automatically
please elaborate.
You could take a log-backup and move that from your db-server.
Check recovery-models in BOL.
If your logfiles grow more than you'd expect, or you've performed an operation causing 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: database owners, users, roles, security
dbo is the default schema SQLserver has implemented.
If a user (lets say User0 )performs "select * from mytable" SQLserver will first search an object...
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: BUG Or What Am I Missing
Should result in 2 rows.
Is this on a multi-processor sqlserver-box ? try queryhint maxdop 1.
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 - 7,201 through 7,215 (of 7,498 total)