248 reputation
310
bio website
location
age 43
visits member for 2 years, 3 months
seen Nov 6 at 7:10

Oct
22
accepted Does a database backup reduce size/increase free space of the log file?
Oct
21
comment Does a database backup reduce size/increase free space of the log file?
Database set to SIMPLE recovery, archived half the data in the database, backed up the database (full). As expected, log file physical size unchanged...UNEXPECTED that the free space in the log is 0.1%...was expecting 99%!
Oct
21
comment Does a database backup reduce size/increase free space of the log file?
As per the question: I don;t expect the file size to reduce, but I WAS expecting the free space to increase?
Oct
21
comment Does a database backup reduce size/increase free space of the log file?
Simple recovery model
Oct
21
asked Does a database backup reduce size/increase free space of the log file?
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