(Robert Pearl) The Plan Cache plays a significant role in the overall performance of your SQL Server. Cached query plans allow for more efficient operations by saving time and resources. Therefore, if you experience a slow-down of your SQL Server Queries and Stored Procedures, it is extremely impor
Other News
Database Data Scripting Guidance
New In-Person Training Courses for Phoenix, Metropolitan Dallas and San Francisco! With our in-person training partner SolidQ, SSWUG is proud to announce three new classes that will take place in February! If you’re interested in learning more about the Microsoft Business Intelligence stack, we have hands-on labs in San Francisco, Phoenix and Irving, TX. Click here to review the upcoming […]
Copying a Large Database Through Scripting
Copying a Large Database Through Scripting I was reminding folks that sometimes we have to revert to the very basic method of copying a database by scripting SQL statements from an existing database for one reason or another. There are many great tools out there that do it naturally. I have used DB Compare with great success for many years. […]
Selecting DOM Elements with jQuery
(Armando Roggio) The jQuery JavaScript library has an excellent, cross-browser selector engine that uses CSS.
Simplify with an XML data model – Part 4
(ud) Data validation prevents data corruption and security risks. This often goes beyond simple data type checking of strings and integers, and can consist of complex business rules such as “email address must be valid” or “if the user does not enter a zip code, they must enter a city and state”.
The Binary Search Tree Data Structure–having fun with XPath 3.0
For a long time I have wanted to play with XSLT 3.0 and XPath 3.0. Despite these being in their WD status, the new features are so powerful and overwhelming.
Customizing SharePoint Online with SharePoint Designer 2010
(Asif Rehmani) Learn how to use SharePoint Designer 2010 to customize and build solutions for SharePoint Online, a service of Office 365.
Q: My SQL Server database shows a very large size, but the sum size of all the tables is nowhere near the size of the database. What should I do?
(John Savill) A: The first step to try is to shrink the database, which is done through SQL Server Management Studio. Right-click the database, and select Tasks, Shrink Database, as the screen shot shows below.
Pagination in Result Set – OFFSET FETCH – SQL Server 2012
(VidhyaSagar) Today I’m going to discuss another new feature in SQL Server 2012. Pagination in result set is a new feature in SQL Server 2012. ORDER BY clause in SQL Server 2012 is enhanced with additional parameters that is OFFSET and FETCH. Using this parameter allows you to fetch data from a part
Getting Started with Business Intelligence Semantic Model (BISM) in SQL Server 2012
(Divya Agrawal) The Business Intelligence Semantic Model is one of the most significant enhancements in SQL Server 2012. BISM allows aspects of the traditional multidimensional model to coexist with the relational model in a format called the tabular model and can be used with all client tools in th