Forum Replies Created
Viewing 15 posts - 6,136 through 6,150 (of 7,505 total)
-
RE: How do I get SQL Server version (numbers only)
select
replace( cast ( serverproperty('ProductVersion')
-
RE: Slow query performance vs 2000
This kind of poor queries will have you suffer long time
here are some more solutions.
I guess the CTE is a good example,...
-
RE: where does my sqlServer2005 insallation store its bak files?
SQL2005 :
declare
@DefaultBackupDirectory nvarchar(512)
exec
master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',...
-
RE: SQL Agent and Domain Server
I guess you better launch a new thread with title "linked server losing connection when domain controller bounced"
Maybe that will encourage some people...
-
RE: Weird Query output
Check the access path :
Maybe it's trying to generate the same path like the one for this query :
SELECT
TOP 50 *
-
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...
-
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...
-
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
-
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....
-
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...
-
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...
-
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...
-
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
)...
-
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...
Viewing 15 posts - 6,136 through 6,150 (of 7,505 total)