Refreshing KPI Data in SSRS 2016
Continuing my blog from last week, Creating KPIs in SQL Reporting Services, I am now going to explain how to...
2016-03-01 (first published: 2016-02-23)
4,166 reads
Continuing my blog from last week, Creating KPIs in SQL Reporting Services, I am now going to explain how to...
2016-03-01 (first published: 2016-02-23)
4,166 reads
As usual, the pager went off...
"Server is near 100% memory utilization - what is running?"
http://www.starshipearththebigpicture.com/wp-content/uploads/2015/09/red-alert-picard-300x228.jpgI saw when I signed on that...
2016-02-29 (first published: 2016-02-23)
7,892 reads
I have been wanting to write this for a long time, and finally got time to do it. Which is...
2016-02-29 (first published: 2016-02-23)
2,762 reads
Today let’s talk about shrinking log files, and Minion Backup – still totally & forever free – and how they go together. First...
2016-02-25 (first published: 2016-02-22)
2,636 reads
This second post of 3 on SSRS 2016 looks at the new features for the SSRS portal and the paginated reports using the...
2016-02-22
1,137 reads
In the Previous blogs we have seen about virtual memory related concepts.
http://sqlandmorewithkruti.blogspot.in/2016/01/memory-fundamentals-for-sql-server.html
We came across concepts like Address Window Extension, Physical...
2016-02-24 (first published: 2016-02-22)
4,102 reads
A short one, but I found myself wasting time recently. I use an Excel sheet to schedule some items out...
2016-02-26 (first published: 2016-02-22)
1,919 reads
This is blog post #2 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel.
If you haven’t been working in SQL Server for very...
2016-02-24 (first published: 2016-02-22)
2,859 reads
This month I challenged the blogging community to share their own creations in Power BI. We got a ton of great entries this month, thank you everyone who participated!...
2016-02-22
35 reads
This month I challenged the blogging community to share their own creations in Power BI. We got a ton of great entries this month, thank you everyone who participated!...
2016-02-22
30 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
Comments posted to this topic are about the item Data Lost in the Cloud
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 two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers