Here at Database Weekly, we scour the Internet with a fine-toothed set of queries to compile the most informative weekly newsletter about SQL Server. Over 670,000 SQL Server professionals rely on it to kick-start their week. Here, we have an assortment of the latest articles from selected sources.
At DatabaseWeekly.com you can sign up for the newsletter and browse the latest news.
I need to attach a file for each result in a query, could be a single result could be 10. Using Microsoft SQL server 2012.
example: `select ItemNumber ...
Please suggest how can we achieve below scenario if possible.
DECLARE @PRODUCT TABLE
[Base Part] VARCHAR (50),
Wanted to know if I can have two ssrs instances on the same server, one in native mode and one in sharepoint ...
I’ve been on a testing kick, trying to formalize the ad hoc queries I’ve run into something that’s easier to track. As a result, when ...
There was a question raised some time back 'If an index is not selective, will the query operators that use it always be index scans'?
It's an interesting ...
how to convert excel version by xlsx to xls by using SSIS/SSRS.
how to skip the data load to the top five records in excel by using SSIS.
I have a CRM app that i've build and this is my biggest query in there. this tables have about 50k-100k rows each and to join all of them and order by ...
I am using SQL 2008R2 (prod server). Total server memory is 20 gb. I assigned for sql 14 GB and setting max and min limit in SQL memory settings. ...
Register here. In our monthly series about Minion Enterprise – the new SQL Server management solution – Sean and Jen will show you how “ME” ...
My article "SSIS Design Pattern - Staging Fixed Width Flat Files" is published on SQLServerCentral.com. In the article, I provide a design pattern for ...
So far in this series I have introduced a couple of tools that are suitable for helping with the management of Extended Events. The tools introduced so ...
Here is an overview of the articles I published in the third quarter of 2015.
Retrieve file sizes from the file system using Power Query
Create a Treemap ...
Hi GuysJust encountered a scenario where I needed to handle numeric and non numeric types using Case statement. Here is the synopsis of challenge ...
Steve looks at the temporal table feature that's coming in SQL Server 2016.
How to track every change to your SQL Server databaseSee ...
Learn how to load fixed width flat files to staging tables in this article from Samuel Vanga.
Minion Enterprise can help you with security management in an enterprise.
Automatic UNDO Management isn't voodoo or black magic, although it can seem that way when it isn't clearly understood. How does Oracle decide how many ...
I have the following case (see image)
For Each student I need to sum periods (Ps) and absents (As) considering only records between Code ...
I wanted to have my daysofweek arranged starting from Thursday >19:00:00pm as 1 , Friday as 2 , saturday ...
Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them is a single most efficient ...
I need to select the newest records in my db table and check it if its older than 1 day
Data Compression is feature of Microsoft SQL Server to reduce the size of table on the basis of Duplicates, Null & Zeroes. It's ...
One of the ways that you take more direct control over your SQL Server instances is through the use of trace flags. There are a number that people recommend ...
It seems as though Git is taking the world by storm as the Version Control System (VCS) of choice. TFS is widely used in the MS world, but Git is growing, ...
So there I was trying to get SharePoint's script on demand (SOD) working correctly and I thought I had ...
There is a wealth of information within Extended Events. Throughout this series, I have been working on exposing that wealth of information. A good bit ...
Well I’ve done it. I’ve spoken at an event. I’ll discuss how I felt about it and what I learned along the way a bit later. But in ...
COURSE ROOM DAYS START END
NETWORKING C 205 Monday 8:00 8:50
NETWORKING C 205 Tuesday 8:00 8:50
NETWORKING C 205 Wednesday ...
We are using SQL server 2012,
We scheduled jobs to run the SSAS Cubes.Sometimes cube is going long running and we are unable detect the issue before the ...
Poor patterns and practices are code smells. Steve Jones notes we have plenty in T-SQL.
If we only use version control as a way to back up our code then it is pure overhead but actually there are real benefits. We can use source control to ...
Links and information about the FOR JSON clause in SQL Server 2016.
The Power Query Formula Language (PQFL) is a functional language that drives the Power BI transformations, and allows you to create mashup queries from ...
Im not doing a tremendous amount of public speaking this year and concentrating on more professional matters, however im pleased to say that on Friday ...
I need a copy of my production database to be loaded to Warehouse daily. I am planning to do it through transactional replication. I have tables in my ...
Thanks for joining us at SQL Saturday Columbus today on a gorgeous day to go inside and learn about SQL Server! And even bigger congrats to those of you ...
Introduction to Atomic CommitIn my previous post, we have discussed how to view and analyze SQLite BLOB data and know why BLOB data is important in SQLite ...