Viewing 15 posts - 17,056 through 17,070 (of 22,210 total)
Pretty sure that's from an encrypted database Roy. I posted on it.
June 30, 2009 at 7:52 am
Sounds like the database was encrypted. It wants the location of the key files and you'll need the passwords that unlock them.
June 30, 2009 at 7:52 am
All those functions on the columns in the JOINS are going to kill performance. They should have in 2000 as well. Can you post the execution plan?
June 30, 2009 at 7:39 am
Two options, identify indexes that are not used or that are too big and eliminate them, as per the previous post. Another option is to upgrade to 2008 and use...
June 30, 2009 at 7:34 am
There is also a lite version of AdventureWorks that includes simpler structures and less data, so that's another alternative (not better, just different) to Northwind. There's also an AdventureWorksDW that...
June 30, 2009 at 7:32 am
GilaMonster (6/30/2009)
Ok, those worked properly.This is seriously weird
It's a secret admirer.
June 30, 2009 at 6:28 am
mazzz (6/30/2009)
I remember reading about the cost figures being estimates, even in the *actual* execution plan - what would one look at instead, to figure out which bit of...
June 30, 2009 at 6:08 am
smsam1 (6/29/2009)
actually what i meant is this, you go through set of values to find a particular value inside that set is comparison,
That would be a WHERE clause within a...
June 30, 2009 at 6:02 am
Yes, it was taken down pending an investigation of violation of the DMCA. Here's more detail [/url]for those that are interested.
June 29, 2009 at 12:13 pm
Passthrough or not, when you send a query up to SQL Server, it gets converted into TSQL syntax because that's the only syntax that SQL Server understands. Although I thought...
June 29, 2009 at 12:03 pm
The question is, how much money do you want to spend. The two tools that I use to do this are System Center Operations Manager from Microsoft and SQL Diagnostic...
June 29, 2009 at 11:59 am
It's using the index on SiteMap2 that has both columns because that makes it a covering index.
Don't use the cost estimates as a measure of query performance. They really...
June 29, 2009 at 11:51 am
charipg (6/29/2009)
As a DBA,1.How to CHECK JOB FAILURES?
SQL Agent in Books Online
2.How to CHECK DISKSPACE?
Performance Monitor counters
3.HOW TO CHECK THE FILEGORWTH ?
Performance Monitor Counters
4.HOW TO TRUNCATE TRANSACTIONAL...
June 29, 2009 at 8:53 am
It is very possible to over-use temp tables and table variables. A lot of developers will load data into a temp table and then go through various joins to other...
June 29, 2009 at 8:23 am
Yeah, that's a huge query and it's going to take a long time to compile. What's more, the size of it, the number of tables it hits, it's going to...
June 29, 2009 at 8:09 am
Viewing 15 posts - 17,056 through 17,070 (of 22,210 total)