Tags » SQL Query

Amazing things with matching strings

I had an occasion recently when it would have been really helpful to know that a new address added to the database was a duplicate of an older, inactivated address. 1,631 more words

Coolness

BI SQL # 280: Get all SQL Server instance information for at a glance

Hi Folks,

In journey of creating Power BI dashboards for DBA I have created this most informative query, which can be useful for everyone.

This query will have most of your sql server instance level information. 1,128 more words

Link

BI SQL # 279 : Get all last back up date and time with physical bak file path

Hi Friends,

Lets see how to Check all last database back up date and time with physical bak file path

In this post we are going to discuss following “how to Check all last database back up date and time with physical bak file path”following points:

166 more words
Query

TSQL - Monitor to check number of records every hour in a given table


-- This monitor collects 6 hours of data collected in mySchema.myTable table. Verifies latest record count with average record count to identify possible data collection error. 226 more words
SQL

Convert Grid Data to DataTable

DataTable dt_Datatable = ((DataView)dg_Grid.ItemsSource).ToTable();

SQL QUERY

Explicitly Insert in an Identity Column in SQL

1. Explicitly Insert in an Identity Column in SQL
–>CREATE TABLE products (id int IDENTITY PRIMARY KEY, product varchar(40))
GO
— Inserting values into products table. 100 more words

SQL QUERY