Viewing 15 posts - 1,861 through 1,875 (of 3,657 total)
I'd turn this on its head. My customer is my boss. That attitude might upset a few line managers but it would help build bridges between IT departments...
December 21, 2011 at 1:45 pm
CyberWomble (12/8/2011)
1.) Are the plans cached by sp_prepexec stored in the same place as the plans cached when using Stored Procedures?
2.) Do...
December 8, 2011 at 7:26 am
I've seen something like this before with linked servers.
In that particular instance the code below alleviated the problem
EXEC master.dbo.sp_serveroption @server=N'YourServer', @optname=N'lazy schema validation', @optvalue=N'true'
Thanks for the star rating. If...
December 8, 2011 at 1:37 am
collins.jmj (12/6/2011)
December 6, 2011 at 10:34 am
The documentation tools so are seem to be focused on getting data out of extended properties, not necessary making the population of those values practical.
At this point I feel...
November 30, 2011 at 3:45 pm
As a teenager I had a job delivering potatoes to fish and chip shops across the staffordshire plains. The boss had a book called a ready-reckoner to help calculate...
October 21, 2011 at 4:07 pm
Joe, I should have remembered that. I think one of your books mentioned storing a calendar table rather than trying to workout calendar maths on the fly.
It is so...
October 19, 2011 at 12:17 pm
Yes, and apparently each space shuttle launch expected at least 6000 components to fail but was still designed to work.
On my list of things not to think about is precisely...
October 19, 2011 at 9:50 am
Well October 14th 1962 was the start of he Cuban missile crisis so has Red-Gate been bought by the Russians?
October 12, 2011 at 8:33 am
Went to an astonishing presentation by Thomas Kejser at SQL Bits where he demonstrated that IDENTITY and in fact NEWSEQUENTIALID() is far slower that GUIDs on SSDs and this is...
October 5, 2011 at 4:31 pm
"This report, by its very length, defends itself against the risk of being read." (Winston Churchill)
The problem with policies and procedures is summed up by the Winston Churchill quote above.
I...
September 28, 2011 at 2:06 pm
There are open-source datasets out there but by their nature they can harbour crap data.
I know of an occassion where someone didn't like the way that the Balleric Islands were...
September 23, 2011 at 12:12 pm
When I started off the most junior position was analyst/programmer. This meant we had to sit infront of people who would eventually use our product. that was nearly...
September 23, 2011 at 12:06 pm
Well the size is half the size of the GUID.
I'm not sure how GUIDs are generated but I'm willing to be there is substantially more calculation involved albeit highly efficient...
September 19, 2011 at 4:03 pm
To answer a few points raised in this discussion thread: -
Good spot on the 84,400. It is a typo but the figure for 4 and 40 years respectively are...
September 15, 2011 at 2:11 pm
Viewing 15 posts - 1,861 through 1,875 (of 3,657 total)