241 reputation
310
bio website
location
age 42
visits member for 1 year, 11 months
seen Aug 26 at 11:14

Jul
31
awarded  Notable Question
Jul
2
awarded  Curious
Jun
11
awarded  Notable Question
Apr
2
comment Find actual data size from a query?
Probably a better way of putting it!
Apr
2
accepted Find actual data size from a query?
Apr
1
asked Find actual data size from a query?
Dec
9
comment T-SQL Query runs quickly on local PC, but slow on SQL Server?
I rebuilt the pertinant indexes and the query time dropped back to 12 seconds...however, I re-ran and it was 17 seconds...then 20 seconds? Something fishy definitely going on...would expect an immediate re-run to be almost instant?
Dec
9
revised T-SQL Query runs quickly on local PC, but slow on SQL Server?
Added hardware facts
Dec
9
comment T-SQL Query runs quickly on local PC, but slow on SQL Server?
command status wait_type last_wait_type blocking_session_id SELECT runnable NULL SOS_SCHEDULER_YIELD 0
Dec
9
comment T-SQL Query runs quickly on local PC, but slow on SQL Server?
OK, I have exe plans from both...I can't see anything obviously different. Any idea how/where to post them?
Dec
9
comment T-SQL Query runs quickly on local PC, but slow on SQL Server?
I'm no DBA - how do I tell about blocking? I am the only one doing anything against the database concerned.
Dec
9
comment T-SQL Query runs quickly on local PC, but slow on SQL Server?
Running both server and local again now with actual plans...4:30am here in qatar so server quiet :)
Dec
9
asked T-SQL Query runs quickly on local PC, but slow on SQL Server?
Nov
18
awarded  Popular Question
Sep
26
awarded  Popular Question
Sep
24
awarded  Yearling
Sep
5
comment Improving performance of query with `WHERE <> ''`
Followed your examples (table has covering indexes) and found the same as you. Table is approx 750,000 rows and found that you are right...the table scan was actually faster - so it seems that this is the most efficient way (and now I know why too!)
Sep
5
accepted Improving performance of query with `WHERE <> ''`
Sep
4
comment Improving performance of query with `WHERE <> ''`
I ran Ctrl-L/Estimated plan and it didn't suggest anything...trying Actual Plan now...same as Ctrl-L...just seems to be slow
Sep
4
comment Improving performance of query with `WHERE <> ''`
About 33% roughly. There are also queries on Currency = '' AND Country <> '' etc. etc.. And also Currency = '' AND Country = ''...which don't seem to be an issue - they run much quicker.