|
|
-
|
|
SQL Azure differs significantly to the typical on-premise solution, and must be monitored and administered with “new thinking”. Index fragmentation is one of the areas where a DBA must scrap the instruction manual and start again....
|
|
-
|
|
My question in the recent Beyond Relational BI Quiz (see
http://beyondrelational.com/quiz/sqlserver/bi/2011/questions/132/use-of-foreign-key-constraints.aspx)
sparked a bit of debate about Foreign Keys, and whether they should be used in a
Data Warehouse. I......
|
|
-
|
|
A little while ago I thought about putting together my own ERD for the DMVs and System Views. Everyone in the world of relational databases knows how important and useful such diagrams are, and in the (apparent) absence of a Microsoft one, after many fruitless searches, I set about putting tog......
|
|
-
|
|
I wanted to find a way to save space when storing text in Windows Azure SQL Database. On-premise SQL Server allows page and row compression, which is currently not available in the cloud. ...
|
|
-
|
|
I came across an issue some time ago when a job of mine was regularly failing with a strange error - Unable to open the physical file “\\”. Operating system error 5: "5(error not found)". The job in question ran monthly, and took a backup of our Data Warehouse database to provide us ......
|
|
-
|
|
SCHEMABINDING is an option that can be applied to Views or
Functions. When used, it forces SQL
Server to create dependencies between any objects referenced within the View or
Function, to the View or Function itself.
What this means is that the referenced objects cannot have their
definitions......
|
|
-
|
|
An application I support uses a BIGINT to store date and
time data. Our installation is SQL
Server 2005, so the lack of accuracy in the datetime data type is probably a
driver behind this.
A small challenge when working with the application’s
database is working out the date and time aga......
|
|