Filtering Logged Data
Explore how to customize the view of the GUI for working with XEvent Log files or XEL files. This further customization does include working with filters.
Related Posts:
Get a List...
2016-01-01
36 reads
Explore how to customize the view of the GUI for working with XEvent Log files or XEL files. This further customization does include working with filters.
Related Posts:
Get a List...
2016-01-01
36 reads
Over the course of the past couple of articles, I have shown some interesting if not useful functionality in the...
2016-01-07 (first published: 2016-01-01)
1,237 reads
Let’s have some fun with operator precedence today. Specifically, logical operator precedence. Specifically, how is it evaluated when your where clause...
2016-01-06 (first published: 2015-12-31)
2,826 reads
Explore how to configure the XEvents GUI with specific views to suit your needs and tastes for data display by adding, removing or changing the column orders.
Related Posts:
Easy Open...
2015-12-31
23 reads
In the previous article I showed a couple of methods to merge Extended Event Log files. In that article I...
2015-12-31
1,035 reads
SQL Server is a database management system which enables to store and retrieve data from the database. Due to some reasons like virus infection, improper closing of the Server,...
2015-12-31
38 reads
SQL Server is a database management system which enables to store and retrieve data from the database. Due to some...
2015-12-31
1,418 reads
Sometimes one receives amazing gifts at the most unexpected moment. I was beyond thrilled to find out that I was...
2015-12-30
844 reads
Thanks to the December 2015 update released for Power BI, we can now use R to visualize our data in...
2016-01-05 (first published: 2015-12-30)
4,930 reads
I ran a twitter poll the other day Do you check for databases with trustworthy turned on when you do...
2016-01-06 (first published: 2015-12-30)
2,482 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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