Forum Replies Created
Viewing 15 posts - 6,256 through 6,270 (of 7,499 total)
-
RE: Adding more than one column
- end you statement with a semicolon ;
- this also can do the trick
alter TABLE [dbName].[dbo].[tableName]
add colx bit not null default 0 ,
coly bit not null default 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: How to export table rows as insert statements
- maybe tablediff utility can do that for you. aarch that's sql2005
- I guess the SQL_Server_2000_Web_Services_Toolkit can do that to.
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 runs in fraction of time when run more than once
table caching is a dangerous thing to do ! because when you pinn a table, it will not be cached out ! Maybe your table grows beyond your expectations consuming...
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 tune opendatasource function in sql server 2k
Maybe DTS can do a better job for you.
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: Have to Improve the performance of Update Statement...
In addition to Pam Abdulla's reply :
If you're updating a varchar-type column, it may be possible sql has to relocate your row to another page, maybe even perform some pagesplits...
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: Service Pack Woes
just try to do an easy
client install using a script when you have vs2005 installed with sqlexpress or when sqlexpress with its...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: sqlserver 2005 transaction log increase to 95 Gb
If this is a full load/refresh or your applications are offline during this load, you might want to disable your Non clustering indexes ( if your data is thrustworthy
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: sqlserver 2005 transaction log increase to 95 Gb
If you have a clustering index defined for your table, when you prepare your data for load, sort it according to your defined clustering index !
This way you avoid page-splits...
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: sqlserver 2005 transaction log increase to 95 Gb
If you change to simple, it will only keep info for the open transactions.
So if your load is in a single transaction, it will still grow to 95 Gb.
Can you...
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: Joining tables with sql authentication
I hope this is a singleshot or investigative query you want to run, because the querytype proposed later on is certainly _not_ a general practise advise !!
connect to your server...
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: Linked Server - Timeout Expired
Well ... handling these kind of problems is not easy .... that's one downside of working with linked servers.
Start sqlserver perfmon to captuer 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: Pivot Table Generator Code
regarding the sqlteam article (good).
there is a downside with using ##pivot.. ##meaning global temp tb.... global = everyone... so only one can use it at a certain time.
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 Size (PSOFT)
Maybe this can help out generating your script :
-- I did change to not include Primary Keys !!
-- You'll have to drop/create the PK-constraints if you want to...
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 Size (PSOFT)
How about statistics ? Do your have autostats enabled for your crm db ?
Every once in a while (3 or 4 /year) manualy perform dbcc updateusage and sp_updatestats. Depending on...
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: Quickly Identify DEADLOCK information from TRACE data
Those traceflags will have SQLserver log deadlockinfo to the SQLServer ErrrorLog-files.
look at yourdrive:\MSSQL\LOG\ERRORLOG
or use EM / Management / Sql server logs
search for Deadlock
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,256 through 6,270 (of 7,499 total)