Viewing 15 posts - 19,966 through 19,980 (of 49,552 total)
In short, you have a corrupt database. (allocation errors have to do with errors in the way that pages are linked to objects, consistency errors have to do with the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 1, 2012 at 12:51 pm
Table and index definitions please?
No other predicates that you could specify (useful, row-limiting ones)? The two predicates in the where clause are not SARGable because of the functions, so there's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 1, 2012 at 12:46 pm
What events are you tracing there?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 1, 2012 at 12:34 pm
If you go with an IF, watch out for this:
http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 1, 2012 at 12:24 pm
siva 20997 (3/1/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 1, 2012 at 12:05 pm
Errrr, it retrieves all rows from the table.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 1, 2012 at 11:35 am
siva 20997 (3/1/2012)
So the bluetooth device is what connects to the database? If so, that probably is one device licence, the phones aren't directly or indirectly accessing the database,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 1, 2012 at 11:34 am
siva 20997 (3/1/2012)
If they agree single cal is enough for this then a IIS allowing multiple users will be a single cal too I think
An IIS server that serves up...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 1, 2012 at 10:33 am
siva 20997 (3/1/2012)
Similarly Mobile phone is not the device. The bluetooth device which recoganises Mobile Phone's presence is the device
So the bluetooth device is what connects to the database? If...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 1, 2012 at 10:29 am
A normal profiler trace should do it, or look in the default trace (should be caught under Audit DBCC Event)
Someone or something is running either CheckDB or CheckTable if you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 1, 2012 at 9:46 am
From books Online:
sp_trace_setfilter [ @traceid = ] trace_id
, [ @columnid = ] column_id
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 1, 2012 at 9:38 am
That's part of checkDB.
Nothing 'triggers' it. It happens when a user or job runs DBCC CheckTable or DBCC CheckDB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 1, 2012 at 9:27 am
siva 20997 (3/1/2012)
My argument that if a factory full of workers swipe a card to clock in, which makes a entry in the SQL server needs...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 1, 2012 at 8:50 am
siva 20997 (3/1/2012)
On a another point. I am thinking of replicating my SQl Server data to SQL Express so that the website can work off that.
I would check with MS...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 1, 2012 at 8:44 am
The Audit Login Failure event?
Sure you're tracing the right instance? If there are login failures in the log, that profiler event will be fires (providing there are no filters...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 1, 2012 at 8:29 am
Viewing 15 posts - 19,966 through 19,980 (of 49,552 total)