Execute at source, and will generate an output with TSQL commands to create temp tables filled with top 50 long lasting queries from all databases.
Then execute output at destination and will do the same and show comparison of matching queries!!
2016-12-19 (first published: 2016-12-06)
791 reads
A brief comparison of three different JDBC Drivers built for connecting with MySQL
2016-05-19
2,702 reads
How do you compare two SQL tables? Every SQL Developer or DBA knows the answer, which is 'it depends'. It is not just the size of the table or the type of data in it but what you want to achieve. Phil Factor sets about to cover the basics and point out some snags and advantages to the various techniques.
2014-06-10
5,867 reads
A set of queries which attempt to gather as much security-related information on a single database as possible.
2015-10-30 (first published: 2013-10-24)
4,991 reads
A set of queries which attempt to gather as much security-related information on a server instance as possible.
2013-11-06 (first published: 2013-10-24)
2,797 reads
I have this peculiar request. We have a library which all developers use to connect to the Production databases. During the course of their interaction with the DB, any Update or Delete statement requires me to take the current state of the Row(s) based on the where clause from the Update/Delete statement and generate all […]
2004-12-07
1 reads
Hi,I like the question. It made me look up once more the meaning of WITH TIES. I also like the answer about dependencies
2004-10-14
If you have SQL Servers list in the database you may run a query that will get a servername from the database, append strings before and after and output in the results window a set of statements like this:SELECT * FROM OPENROWSET('SQLOLEDB','Provider=SQLOLEDB;Server=MyServerName123;Trusted_Connection=yes','select @@servername, <put here everything you want to select according to postings above')Then copy […]
2004-10-11
I am writing a report and the users and they would like to select the grouping of the report.All the grouping will be on a single datetime field (oddly enough named datetime).They would like to be able to choose if the report is grouped by half hour, day, week, or month.I can accomplish day by […]
2004-04-15
1 reads
If your users are connecting through an application server you can put the SQL Server behind a firewall and just allow access through the firewall to the app server IP address, thus denying enyone else access.
2004-03-04
Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we...
By DataOnWheels
Making multilingual reports in Power BI requires a lot of different elements. Translations can...
By Steve Jones
Today’s coping tip is to make a meal using a recipe or ingredient you’ve...
I have 2 tables . tblStudentMarksOriginal - StudID, Subject, Marks 101, english, 91 101,...
I am using sql server 2017. I am trying to use the in operator,...
Comments posted to this topic are about the item Basic Checks on a New...
Ask SSC