Viewing 15 posts - 33,226 through 33,240 (of 49,552 total)
H-122523 (4/1/2010)
Yes, indeed!, You also?
Yup. Degree in physics, haven't used it much recently (except for making up realistic-sounding explanations of non-existent SQL commands)
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
April 1, 2010 at 4:13 am
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
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
April 1, 2010 at 4:01 am
tlough (4/1/2010)
Instead of an arbitrary baseline of 1/1/1900 for datetime, maybe something more memorable....like 4/1/1900?
What's special about the 4th of January? 😉
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
April 1, 2010 at 3:55 am
H-122523 (4/1/2010)
137 is an odd answer, in more than one way actually...
I'll take the blame for that value.
1/137 is (aprox) the value of the fine structure constant, used in...
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
April 1, 2010 at 3:54 am
Awesome. Love the latter half.
They will expect to see various diagrams an code such as this.
psychological research has shown that some people will only read the first few words of...
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
April 1, 2010 at 3:44 am
Steve Jones - Editor (3/31/2010)
I'll try to get through this thread, once I remove about 600 messages from my email
Ctrl-A, Shift-Del
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
April 1, 2010 at 3:34 am
Have you read through Books Online? There's info on all of those in there (well, except no 7)
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
April 1, 2010 at 3:34 am
Then you have transient IO problems. Are you seeing any 825 errors in your error log?
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 31, 2010 at 4:32 pm
Lynn Pettis (3/31/2010)
GilaMonster (3/31/2010)
WayneS (3/31/2010)
dma-669038 (3/31/2010)
One guy i talked to did not know the difference between table scan and index seek except that 'it ran faster')
Makes me wonder what he...
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 31, 2010 at 3:16 pm
WayneS (3/31/2010)
dma-669038 (3/31/2010)
One guy i talked to did not know the difference between table scan and index seek except that 'it ran faster')
Makes me wonder what he thinks the difference...
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 31, 2010 at 2:50 pm
Alex V (3/31/2010)
Looked and deleted the database from the list of publishers.
Should be possible to disable distribution completely. I'll investigate for you tomorrow.
This database is set for simple recovery. Currently,...
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 31, 2010 at 2:26 pm
Please post complete table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Have you considered normalising that 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 31, 2010 at 2:04 pm
Alex V (3/31/2010)
OK. Figured out the DBO error, changed the ownership of the database and deleted replication publication.Do I need to delete all the agent jobs related to replication manually?
They...
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 31, 2010 at 1:54 pm
dwh-1095413 (3/31/2010)
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 31, 2010 at 10:40 am
Ok, good.
This probably looks a little strange, but does generally fix the problem.
Create a transactional replication publication on that database and publish a single table. Doesn't matter which table. Wizard...
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 31, 2010 at 10:33 am
Viewing 15 posts - 33,226 through 33,240 (of 49,552 total)