How much of an improvement in processing time can a simple SQL Server Analysis Services (SSAS) partitioning structure provide? Can you provide any examples? Does this processing time improvement only apply to the fact tables? Check out this tip to learn more.
2013-08-19
4,512 reads
Though the Key/Value pair paradigm is common to almost every computer language, there is no clear agreement yet for the definition of a Key/Value Pair database. However, Key/Value pair databases are valuable for special applications where speed of writing data is more important than searching and general versatility. Buck Woody experiments.
2013-08-16
3,457 reads
This article describes different methods for deploying your SSIS projects to a server.
2013-08-15
10,048 reads
I’ve introduced my manager to SQL Server’s cloud based platform, SQL Azure and Windows Azure Virtual Machine. He wants to test functionality with some of our applications, which would require me to move my on premise databases to the Azure Virtual Machine. What is the easiest way to accomplish this task? See how it is done in this tip.
2013-08-15
2,928 reads
The SQLServerCentral.com survey will end on Wednesday August 21st. Let us know how we're doing and be in with a chance to win a $100 Amazon gift card. Winners will be announced later that week.
2013-08-15
2,625 reads
In this article Greg Larson outlines the exciting new features that come along with SQL Server 2014. He'll also let you know where you can download CTP1, as well as where you can find additional resources related to SQL Server 2014.
2013-08-14
4,381 reads
Specialized tasks like cryptography require external libraries that are not available in SQL Server. Methods for such tasks can be compiled in a .NET language and deployed to SQL Server as a CLR assembly where the assembly's methods can be referenced by SQL Server stored procedures and functions.
2013-08-13
9,029 reads
Join Red Gate for a free seminar on September 20 (the day before SQL Saturday San Diego). SQL Server MVPs, Steve Jones and Grant Fritchey will present informative sessions featuring best practices for SQL Server database administration, in addition to showing Red Gate tools in action.
2013-08-13
1,611 reads
Some SQL problems are intriguing because, just when good methods emerge and are accepted, other alternative solutions are discovered. The fun of exploring problems such as 'Gaps and Islands' is all the greater when we have a thorough test-harness to try out the alternative solutions.
2013-08-13
2,738 reads
This PASS VC Webinar will take place August 14, 1PM EDT. Creatively resolving differences and negotiating mutually beneficial agreements is crucial in all walks of life. It’s especially important and challenging in the IT industry where soft skills are not necessarily prevalent. ??In this session, we’ll introduce the basic concepts and precepts that will aid you in negotiating better agreements with your neighbors, peers and co-workers, and even your boss.
2013-08-12
2,763 reads
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
As a data & AI strategist who’s seen countless projects succeed and fail, I...
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
We are planning on a fairly big code deployment to set the stage for...
Experts, I am hoping to get some help and feedback. I have a server...
Comments posted to this topic are about the item Single User SQL Server on...
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers