Viewing 15 posts - 61 through 75 (of 154 total)
1. Kinda - Cadets for 2 years and they did cover most of the basic training.
2. Absolutely. But it shouldn't cover any particular flavour of database, including SQL.
I know that's...
July 6, 2011 at 1:04 am
scottm30 (7/5/2011)
The moment they are dropped, users will believe the system is running slower. Furthermore any application problems will be initially blamed on the missing indexes.
So don't tell...
July 6, 2011 at 12:40 am
Good article covering a common situation. Indexes are created because we assume they will be the access path (as pointed out in the DateTime discussion) but because they either aren't...
July 5, 2011 at 5:01 pm
Back when school was cool (and storage expensive!) they taught us not to store calculated information.
I suspect that all of the functions presented here are lower cost than a read.
April 28, 2011 at 7:17 pm
My personal favourite
SELECT
DATEPART(dd, DATEADD(dd, DATEPART(dd, DATEADD(mm, 1, @day)) * -1, DATEADD(mm, 1, @day)))
I suspect you would be hard pressed to notice the difference between any...
April 27, 2011 at 1:04 am
Fair enough! I wasn't convinced this was a "good" approach.
So I'll turn this question around a little bit.
How do people quality check code pro-actively? What tools should we be using...
March 20, 2011 at 8:44 pm
A good guide to the capabilities of the NoSQL environments is the diagram on Nathan Hurst's blog. http://blog.nahurst.com/visual-guide-to-nosql-systems
As I continue to work with computers and in the industry, the more...
March 14, 2011 at 4:24 pm
Assuming SQL 2005+
It is theoretically possible that you could into trouble if you use the READ UNCOMMITTED transaction isolation level. You could potentially get dirty reads in the SELECT. That...
March 8, 2011 at 4:44 pm
Not only do Microsoft offer a course in Licensing, you need to have a qualified staff member to be a Microsoft Partner.
The plethora of different versions of all the products...
February 1, 2011 at 3:52 pm
Been a big fan of CONVERT since I discovered you could use it when converting strings back to dates as well!
For the ultra purist uses the fact that with date...
January 20, 2011 at 3:29 pm
Learning new stuff - Always great 🙂
@Nils - I'm sure there is an article of Service Broker just waiting to come out and educate us all. Thanks for the info
January 10, 2011 at 3:11 pm
I'd have to agree with that suggestion vehemently...
Second reason - Your still inside the transaction and locking thise resources. Someone else is waiting!
Edit: I know thats what Jeff said! I'm...
January 6, 2011 at 11:30 pm
If you need to rebuild your indexes that often then I would suggest that you look at rebuilding with a lower fill-factor and pad-index.
For the log shipping, think about it...
January 6, 2011 at 3:45 pm
We want to scan the *complete data in less than 1 hour* - which is possible with our direct attached storage now
I question this, but will bow to your experience....
January 3, 2011 at 3:05 pm
Just to be capable of handling future changes in the workflow, like this one that I'm dealing now, and don't need to redesign the tables...
I'm sorry to say that I...
January 3, 2011 at 2:58 pm
Viewing 15 posts - 61 through 75 (of 154 total)