Forum Replies Created
Viewing 15 posts - 7,051 through 7,065 (of 7,498 total)
-
RE: Linked servers and Cross Server Triggers.
- Because your goal is to move the db to a new server and postpone application-adaption, maybe you can consider to move the db's and at the old location only...
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 2K Performance Issues
When reindexing put your recovery model to bulk-logged or your log will grow by the size of the rebuild data.
.But don't let this discourage...
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: Know database current users
alter database myowndb set offline with ROLLBACK IMMEDIATE will do the job
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: Back to basics - JOINs
- your execution plan will clarify this
- as always " it depends "
* wich type of join are you using (inner /left-right...
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: non clustered index strategy?
rule nĀ° 1 on every rdbms : tell your engine what you know
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: PAE, awe and 3GB
my 2ct
I suppose you've already checked :
- http://www.sqlservercentral.com/columnists/jsack/aweadventures.asp
- http://www.sql-server-performance.com/awe_memory.asp
- http://www.devarticles.com/c/a/SQL-Server/How-to-Perform-a-SQL-Server-Performance-Audit/4/
- use perfmon to check on your I/O activity
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: big query conversion problem
- SQL92-standard adaption.
- access-engine is not sqlserver-engine
- maybe it's on the wishlist for sql2k5
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: big query conversion problem
select col1 + col1 as expr1, (col1 + col1 )* 2 as twice_expr1
from a_table
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: Sum of Product (Mod 10) Checksum
did you look at BOL for CHECKSUM ?
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: Industry standard for Check Digit
imo a modulus is jus a math-exercise, so leading zeroes do not matter, but for correctness allways have them leading your string and handle the CD in your input-presentation layer...
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: Trying to compare date fields
maybe this is a start ...
select t1.date1, identifier1, data1
from table1 t1
where t1.date1 between (select min(date2)
from table2 t2min
where t2min.identifier2 = t1.identifier1
and t2min.date2 > t1.date1)
and (select...
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 DBREINDEX Questions
- A rebuildindex will lock the object involved, so might interfere with your apps
- indexdefrag will not optimize as good as rebuildindex
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: non clustered index strategy?
afaik (my guideline)
if the keyvalue(-combination) of your clustered ix is unique, it is designed to be the same.
if not, sqlserver will add a uniquifier to the clustering-index-key(s).
But in this case,...
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: Equivalence of UNSIGNED in T-SQL
- you might use constraints to limit the numbers so only positive values are allowed.
- you could use a trigger so negative values are converted to positive values.
- but why...
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: Read only access to user tables
don't know if it helps...
strConn = strConn & " INTEGRATED SECURITY='sspi';"
quotes added
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,051 through 7,065 (of 7,498 total)