Indexes and their Effect on Query Performance
Indexes play a huge role in the performance of a query. Without indexes, you very simple query to get the...
2010-07-29
971 reads
BrianKMcDonald
Checking Users AD Groups Using Windows CMD
Blog Title: Checking Users AD Groups Using Windows CMD
Depending on your role in the organization, there may be a time...
2010-07-29
1,058 reads
Limiting Table Access for Reporting Part 2
Blog Title: Limiting Table Access for Reporting Part 2
In the first blog post of this series, I showed you how...
2010-07-29
560 reads
Limiting Table Access for Reporting Part 1
End users may have a need to do some form of reporting of data from source systems. Opening up the...
2010-07-29
454 reads
Jacksonville Code Camp – Introduction to Reporting Services 8.28.2010
The 6th Annual Jacksonville Code Camp is coming up fast. There are tons of great presenters slated to be here...
2010-07-26
375 reads
JULY 31: SQL Saturday 40
SQL Saturday #40 is quickly approaching and many are gearing up for the trip down there to hear some awesome...
2010-07-20
477 reads
Increasing or Decreasing Sampling Size in SSAS Data Source View Data Explorer
Recently, I have begun my quest of mastering SSAS. I realize that it may take time and I am more...
2010-07-19
496 reads
Updating Email Addresses in SSRS Subscriptions
Creating subscriptions in SQL Server Reporting Services is a great way to distribute files to end users. If it has...
2010-07-19
16,089 reads
Strange But True: Report Builder 2.0 Crashing
Recently, I have been given the opportunity to work with a company who wanted to explore the capabilities of Report...
2010-07-18
352 reads
Report Builder Stand Alone Installation
If you’re planning on rolling out Report Builder to end users, you may want to download the stand alone installation...
2010-07-18
567 reads
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
What is the best index strategy for a table that gets truncated?
Hi everyone My SSIS package does a bulk insert of csv files into a...
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers