You need a quiet couple of hours poking about with DMVs, and checking execution plans to get to the bottom of the a query issue, but you can't make a copy the production database either. It's too big, and the data is private....
2012-03-26
211 reads
This Friday Steve Jones asks about maintenance. Do you have regular windows? Flex time? Or is maintenance just added on whenever it is needed and added onto your work week.
2012-03-23
126 reads
Today we have a guest editorial from Andy Warren as Steve Jones is on vacation. Today Andy talks about personality tests and what they might tell you about yourself.
2012-03-22
372 reads
Today Steve Jones talks about the pace of data growth looking to outpace the IT budget changes. As data professionals, we need to learn to do more with less.
2012-03-21
218 reads
How can a company attract talent? First, be a good company to work for, and then be real.
2012-03-20
187 reads
A disconnected model is only really needed in the absence of a properly-defined database interface. We, as developers, create a rod for our own backs by insisting on treating a database in a way we wouldn't treat an object, let alone an assembly or namespace.
2012-03-19
126 reads
Today Steve Jones talks about one of the classic software developer debates. When formatting code, how should you do it?
2012-03-19
416 reads
This Friday Steve Jones wants to ask a poll about SQL Server 2012. Do you think it's ready for your production servers?
2012-03-16
161 reads
Today we have a guest editorial from Andy Warren as Steve is on vacation. Was this a good week for you? How do you know? Do you have a definition that helps you determine if it was a good week? Today Andy Warren talks about how we view our jobs.
2012-03-15
119 reads
Recently the Azure service had an outage and Steve Jones has a few comments on this and why it might not be worse than your own company's IT group.
2012-03-14
160 reads
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Have you ever wondered where a certain field is used in a report? Or...
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
Comments posted to this topic are about the item Lies You Should Believe -...
Comments posted to this topic are about the item A Strange Query
Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...
What does this return?
SELECT x=1 WHERE (SELECT 1) IN ( 1, 2, 3)See possible answers