2019-01-11
3,533 reads
Query
Query Performance comparison between instances
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)
782 reads
8 Ways to Export SQL Results To a Text File
This tip will show eight ways to export the results of a query to a text file.
2017-10-06 (first published: 2016-10-26)
332,638 reads
Data Mining Part 37: The Data Mining query transformation task
This new chapter will show you how to work with the SSIS Data Mining Query Transformation Task
2016-04-14
2,108 reads
2012-04-26 (first published: 2012-04-02)
994 reads
SQL or MDX query trace in SSRS - trick of imagination or a real thing?
I sometimes have ghost memories - I remember some things that had never in fact happened. And I was wondering if ...
2010-09-03
2,456 reads
2005-05-30
1 reads
Identifying NULL Dates
I'm writing a TSQL procedure using a CASE statement to display a NULL date represented as '1900-01-01 00:00:00.000' as a '' string but having no success. I've tried IS NULL, direct comparisons, using DATEDIFF and comparing against GETDATE(), and CASTing the value to nvarchar and comparing. Any help would be appreciated.
2005-05-12
6,137 reads
RE: I need a replacement! (Chicago Suburbs)
Hi Josh Is this a consulting position or a permanent one ? Also would the company sponsor visa (H1 B) ? I have a Masters from Louisiana State University and am currently working on Sql Server Reporting Services/VB.NET and I have about 4 years of experience with Sql Server 2000. Dinakar
2005-04-26
How to generate SQL DML
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
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers