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
Daniel Farina demonstrates how to create and test hypothetical indexes with the undocumented DBCC AUTOPILOT command.
2014-06-13
3,858 reads
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
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
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
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
You can map a drive, just have to make sure it's mapped under the agent account.
2004-02-27
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
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
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
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
backup log to int run every hour. If a log init backup is run...
Comments posted to this topic are about the item Speakers Are Normal People