Building SQL ConstantCare®: Analyzing Query Plans
Starting to translate sp_BlitzCache into the cloud.
2018-07-27
4,046 reads
constants
Constant Data Types
Data types are an important part of how tables and variables work. Did you know that constants have databases too?
2016-10-03
1,639 reads
RE: UDF in computed column of Temp table fails
it seems you cannot reference a udf in a computed col from any other database not just tempdb. You would have to create the function in tempdb. i.e - this does not work either:use pubs gocreate function udf_isblank(@n varchar(20) = null, @ret varchar(20)) returns varchar(20)as begindeclare @null int set @null = case when isnull(@n,'') = […]
2005-04-15
Error(-2147221423) on Analysis Services
I don't know if this should be here or in Analysis Services but I don't want to cross post. We are having an intermittent problem building one of our 20 cubes. It fails with the error : Error(-2147221423): Unable to open server object (Internal (Database 'Endeva' could not be opened on the server)); Time:11/11/2004 06:36:30. Two […]
2004-11-11
3 reads
Blogs
How I implemented database migration on AWS using AWS DMS
As a Software Engineer, I would like to replicate a copy of my database...
My personal experience dockerizing a Rust Application: Deploy to AWS ECR using Github Actions
I have heard about many interesting things about programming in Rust and I decided...
The Importance of Patch Management to Avoid Downtime
A recent Microsoft outage caused by a bad patch pushed out to Windows instances...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers