Why the MS Power Query (PQ) for Excel is an invaluable Business Intelligence tool
Dear reader, I would like to share with you some of the capabilities that the Power Query for Excel brings...
2013-08-22 (first published: 2013-08-19)
4,878 reads
Power Query
Using Parameters in Power Query Extracts
Introduction
By now you have likely heard a little about Power Query (formally known as Data Explorer). While you may have...
2013-08-14 (first published: 2013-08-07)
5,046 reads
RE: DB Growth Issue
What version of SQL are you running. There is a problem (bug) in 7.0 that would cause this to happen. After much effort back and forth with MS, they confirmed it a bug.It is fixed in 2K
2004-08-17
RE: Trigger to update field in a new record
Watch out for multi-row operations in triggers.CREATE TRIGGER trNumber ON tbl FOR INSERT, UPDATE ASUPDATE t SET Number = i.ID FROM tbl t INNER JOIN inserted i ON t.pk = i.pk WHERE i.Number IS NULL
2004-08-13
RE: import .txt file with 00/00/0000 dates causing error
Glad it worked out for You. For data manipulation / cleaning I always use SQL. In DTS, if I use it, I put as little business logic as possible, if any. The staging table approach is very efficient and fault proof. *sql/bulkinsert/dts/bcp **SQL DirtySource ->* StageTable --cleanvalidatelogerrors-->** ProductionTable /rockmoose
2004-07-16
RE: Need help implementing FILO ordering on fixed size database
For our 24x7 website we have a number of tables that record session information, including each page a user visited. this table averages around 4-5mil records. To keep the size manageable, we run a job every hour which moves records older than 60 days into an archive database. We used to run it every day […]
2004-06-22
RE: Baffling Sql2k backup times
We had a similar issue - backup times had gone up drastically - and it turned out that 1 of the disks in the array had gone bad - as soon as we replaced that disk - the backup time came down to normal.- DK
2004-03-09
RE: sp_spaceused tablename for each database
And Expanding on Mohammed Excellent idea:DECLARE @SQL NVarchar(4000) if OBJECT_ID('tempdb..#T1') IS NOT NULL drop table #T1 create table #T1 ([name] varchar(60) , [rows] varchar(11) , reserved varchar(11) , data varchar(11) , index_size varchar(11) , unused varchar(11) , DBName nvarchar(128))SET @SQL = ' SET NOCOUNT ON ' SELECT @SQL = @SQL + ' INSERT INTO #T1 […]
2004-02-20
2004-02-19
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