SQL Server Performance Tuning with Hypothetical Indexes
Daniel Farina demonstrates how to create and test hypothetical indexes with the undocumented DBCC AUTOPILOT command.
2014-06-13
3,858 reads
Tips and tricks
How to hot-add a vCPU to a virtual SQL Server
One of the benefits of running SQL on virtual environment is the capability to present additional vCPUs to the virtual server online and real-time without interruption to running processes. Our VM administrator normally presents only 1 vCPU on the virtual server and extends as required. This article describes how SQL Server is able to detect hot-added vCPUs in my virtual server.
2013-10-18
2,865 reads
SQL Server Integration Services Connection Manager Tips and Tricks
In this article, we will take a look at the following Tips and Tricks for Connection Managers: Adding an "Application Name" property to the connection string; Creating Two Connection Managers for each Database Connection; and Capturing Connection Manager details in Package Configurations
2013-10-15
5,063 reads
SQL Server Reporting Services Tips and Tricks to Improve the End User Experience
In this article we'll take a look at the following Tips and Tricks for SSRS: Display Total Number of Pages while Navigating, Display Everything in a Single Page, Display Report Parameter Selection, Display No Rows Error Message, Page Settings for Optimal Printing.
2013-09-03
5,988 reads
SSRS Expressions Tips and Tricks
Some of the expressions and functions that have come in handy while developing reports in SSRS
2009-12-21
34,643 reads
2004-04-16
RE: Easier way to use a path
You can map a drive, just have to make sure it's mapped under the agent account.
2004-02-27
Easier way to use a path
Is there an easier way to refer to a path, such as:\\servername\f$\folder 1\folder 2\folder n\application.exeCan I somehow give this path a "logical" name so that I can refer to that, instead of the long path everytime I use it in a job ?I have a server that points to other servers via jobs (enterprise mgr) […]
2004-02-27
Online Resources
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-02-23
RE: Storing an Excel Sheet in an SQL field.
Ok, some thoughts about why you shouldn't put them in the DB. I will grant you this is a bit old school in thinking but it is something to consider. Why put something in a database -- You need to search on it -- You need to really control access and NTFS security is too […]
2003-06-23
Blogs
Daily Coping 26 Jan 2023
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
Working With Tags in FlashArray using PowerShell
Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...
Using SQL Data Compare from the Command Line with a Project
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
Forums
Backup Log Init run again by mistake manually.
backup log to int run every hour. If a log init backup is run...
Speakers Are Normal People
Comments posted to this topic are about the item Speakers Are Normal People
Ask SSC