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)
April 1, 2010 at 4:13 am
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? 😉
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...
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...
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
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)
April 1, 2010 at 3:34 am
Then you have transient IO problems. Are you seeing any 825 errors in your error log?
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...
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...
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,...
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?
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...
March 31, 2010 at 1:54 pm
dwh-1095413 (3/31/2010)
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...
March 31, 2010 at 10:33 am
Viewing 15 posts - 33,226 through 33,240 (of 49,552 total)