Using SQL Server and R Services for analyzing DBA Tasks
Article shows how R Services can help database administrators with their daily work
2019-02-22 (first published: 2017-02-07)
2,700 reads
Baseline
How to Install and Configure Baseline Collector Solution V2
In this article I go through the installation and configuration processes of my Baseline Collector Solution.
2015-11-12
2,801 reads
Baseline Collector Solution V2
New version of the Free Baseline Collector Solution released. Do you collect baseline data? If not, let's start doing it!
2015-09-21
5,358 reads
Comprehensive Baseline Collector Solution (Updated)
There are no more excuses for not having baseline data. This article introduces a comprehensive Free Baseline Collector Solution
2016-09-02 (first published: 2014-10-21)
12,048 reads
RE: Copy SP
INSERT INTO tbl2 (fname) SELECT fname FROM tbl1 WHERE ref#='123'Btw, the # sign isn't really good to be used as a column name. I have seen several threads here, where this caused more or less severe problems.
2004-12-16
RE: Database Maintenance Plan in Enterprise Mgr
I am encountering the same problem with MSDE 2000 Sp3. I have not discovered a fix for it yet.
2004-08-26
2004-08-16
RE: How To Return Results from EXEC of Dynamic SQL
hey jim, i think this should do the trick:CREATE PROCEDURE dbo.usp_dyna_cast(@ReturnValue sql_variant OUTPUT) AS BEGIN SET NOCOUNT ON DECLARE @DisplayValue AS VARCHAR(255), @ItemType AS VARCHAR(255) SELECT @DisplayValue = Display_Value, @ItemType = Item_Type FROM MyTable ... DECLARE @stmt AS NVARCHAR(750) SET @stmt = N'SELECT @ReturnValue = CAST(' + N'''' + CAST(@DisplayValue AS NVARCHAR(255)) […]
2004-07-18
RE: facing a 50% line limit when loading text file
i've used to use the BCP program to import data and never had a problem, aslong as I didnt get the row and column terminators confused - which i do often, as im usually bulk loading in the middle of hte night and nursing it thru manually... but thats besides the point.since then, I have […]
2004-07-16
image files
HELP! I need to save an image file - SOMEHOW - to a column in the database. I am using Visual Basic as the interface program, and I have no clue how to go about this. I have been warned that it is bet NOT to save images to the database but is this true […]
2004-07-07
15 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