Data Growth
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
220 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
220 reads
How can a company attract talent? First, be a good company to work for, and then be real.
2012-03-20
190 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
135 reads
Today Steve Jones talks about one of the classic software developer debates. When formatting code, how should you do it?
2012-03-19
432 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
163 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
122 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
162 reads
Steve Jones wonders today if data professionals get a little too hung up on the consistency issues between servers.
2012-03-13
145 reads
This past week the big news in the SQL Server space was the release to manufacturing of SQL Server 2012.
2012-03-12
383 reads
This Friday Steve Jones wants to know about the older versions you are running in your production environments. Are you still using SQL Server 2000?
2012-03-09
178 reads
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Be Wary of Data
Comments posted to this topic are about the item Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;