Moneyball And The DBA
“Moneyball” has been a thing for a while now. It’s shorthand for the application of quantitative data analysis to the...
2018-09-05 (first published: 2018-08-17)
3,061 reads
“Moneyball” has been a thing for a while now. It’s shorthand for the application of quantitative data analysis to the...
2018-09-05 (first published: 2018-08-17)
3,061 reads
SQL Prompt is amazing and it’s my favorite tool. It’s actually what many people want first from Redgate because it...
2018-08-17
465 reads
Views help our query writing by simplifying writing the same sentences and/or aggregations over and over again, but it has...
2018-08-17
363 reads
Error: Generic error: ExpressionChangedAfterItHasBeenCheckedError: Expression has changed after it was checked. Previous value: 'isLoading: [object Object]'. Current value: 'isLoading: true'Resolution:setTimeout the code that is setting the value. In my case,...
2018-08-17
198 reads
Error: Generic error: ExpressionChangedAfterItHasBeenCheckedError: Expression has changed after it was checked. Previous value: 'isLoading: [object Object]'. Current value: 'isLoading: true'
Resolution:
setTimeout the...
2018-08-17
1,249 reads
I am very happy to announce that after a long time struggling and filling all the requirements, we were able...
2018-08-16
733 reads
I’ve just published a new SQLChallenge course for subscribers, and I think it’s one of the best ones yet. Your mission is to: Identify which statement is slowing down...
2018-08-16
33 reads
Permissions are a common concern. One of the most frequent requests I get is I need X, Y and Z...
2018-08-29 (first published: 2018-08-16)
3,211 reads
In dbachecks we enable people to see what checks are available by running Get-DbcCheck. This gives a number of properties including...
2018-08-16
347 reads
Have you ever heard of SQL Reserved vCores? Well I never until recently. With this concept you have the ability...
2018-08-16
350 reads
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
As for me, I'll keep writing whenever time permits. I don't expect every post...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Switching Schemas I
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers