Forum Replies Created
Viewing 15 posts - 6,136 through 6,150 (of 7,499 total)
-
RE: Slow query performance vs 2000
you also might have been better of starting with a [rebuild of your indexes] / maintenceplan , a dbcc updateusage(0) with count_rows and a sp_updatestats !
The depricated part is 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: firehose mode
connection.BeginTrans() switches your connection to "implicit transactions" !!
Everything you do on that connection will automatic start a new transaction, unless there is allready one. This means you'll have...
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: Joins vs Where
also for readability of (outer) joins, using the JOIN-syntax delivers more clear separation of join-predicate and filter-predicate.
The optimizer mostly optimises to a fairly equal plan
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 Agent and Domain Server
the problem is that these jobs are owned by a windows domain user !
They get authorised every time the job is launched by sqlagent....
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: recommended trace flags to set at MSSQLServer startup
-those are also the only ones in use overhere
FYI with SQL2005 I altered -T1204 to -T1222 altough it was not mandatory
- we also alter the Audit level from none...
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: use of union statement
I completely overlooked the s.ord_num as being the sortordernumber you wanted to use. That's why I added my own ordercol containing 0 or 1.
how about this
select maintitle
from (
select -1 as...
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: Setting Query Analyzer message display buffering in SQL serve2005
in your case, the "go"-solution will not work !
You're stuck with Mike John's solution.
Maybe a "select @cnt" may serve you well enough...
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: use of union statement
how about :
select maintitle
from (
select 0 as ordercol, 'this book at top of the list' AS 'maintitle'
union
select 1 as ordercol, t.title AS 'maintitle'
from titles t, sales s
where t.title_id = s.title_id
)...
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: Setting Query Analyzer message display buffering in SQL serve2005
maybe the "dodgy" GO statement can help you out..
print 'myfirtsnotification'
go
work work work
go
print 'mysecond notification'
go
.....
Keep in mind when using the GO, you'll loose all declared variables (or have to redefine them...
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 shrink file does not shrink the data file?
you may want to refresh statistics before you go on ...
print
'-- Usage ' + db_name()...
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: Small table is really slow...
- it's useless to create the index if there is only one value. The chance of it being used is fairly equal to 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: Small table is really slow...
you are always performing a full table scan because you did not provide an index for [ProducerId]
This way (b)locking and waits will occur !!
Jus create an index 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: How to solve this senario???
- Is this meaning you want your column "workfunction" to be a bitmap ?
check out the implications !!
- http://www.sqlservercentral.com/columnists/dpoole/usingbitstostoredata.asp
- you would need a function with cursor (or temptb)...
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: Automate a TSQL at a specified time?
Thats exactly what SQLAgent is doing !
Enterprise Manager / Management / SQLAgent / Jobs
Create a new job, add a jobstep containing your SQLscript,...
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 insert PK automatically?
Works fine overhere ...
CREATE TABLE [BillPayment] (
[billpaymentId] [int] IDENTITY (1, 1) NOT NULL ,
[billPaymentDate] [datetime] NULL ,
[newBillBalance] [float] NULL ,
[billAmount] [float] NULL ,
CONSTRAINT [PK_BillPayment] PRIMARY KEY CLUSTERED
(
[billpaymentId]
 
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,136 through 6,150 (of 7,499 total)