|
|
-
|
|
Here is a quick example of when using temporary tables will give you a big performance gain. I recently was given this query to improve, as it was taking over 15 hours to run:
SELECT *
FROM
(
SELECT * FROM
GL_Star_FactsDetails GL
LEFT JOIN DimAccount ACCT on GL.Account = ACCT.AccountRapidDe......
|
|
-
|
|
To expand on what I talked about in SQL Server 2012 (“Denali”): Details on the next version of SSAS, there is a new data model called Tabular. So when you are creating a new project, which model should you use, Multidimensional vs Tabular? Well, there is...
|
|
-
|
|
As a follow-up to my posts SQL Server “Denali”: New Certifications and SQL Server 2012: New Certifications, there are now final details coming out about the SQL Server 2012 certifications. The major news:
Two new Professional-level certifications will be...
|
|
-
|
|
If you have been creating SSIS packages in Business Intelligence Development Studio (BIDS) for any length of time, you have likely noticed that SSIS packages run slower in BIDS as opposed to running them in a SQL Server agent job (which uses the command prompt utility DTEXEC) or when in integration ......
|
|
-
|
|
Parallel execution in SSIS improves performance on computers that have multiple physical or logical processors. To support parallel execution of different tasks in a package, SSIS uses two properties: MaxConcurrentExecutables and EngineThreads. If you are like me, you probably did not even know ab......
|
|
-
|
|
Now that SQL Server 2012 RTM is out, I have an update to my blog post SQL Server 2012 (“Denali”): Installing on a Virtual Machine, which was for CTP3. Here is the version for the RTM:
The steps below are what I took to create a virtual machine to install ...
|
|
-
|
|
When creating a new cube in SSAS, you are frequently making changes that cause the whole cube to reprocess when you use the “Deploy” option (such as structure changes or aggregation design changes). This means a lot of sitting around and waiti...
|
|
-
|
|
My previous blog, SQL Server 2012 (“Denali”): Details on the next version of SSAS, talked about the major new feature in SSAS, which is BISM. But what other changes are there? Well, not much. Here are details on the few changes I have found:
All develo...
|
|
-
|
|
As a follow-up to my SQL Server 2012: New Certification Info, Microsoft Learning has announced the certification tracks for the SQL Server 2012 exams. There are new names for the certifications:
Your first step is to achieve Microsoft Certified Solutions ...
|
|
-
|
|
Are you a salaried employee looking to switch to a W-2 or 1099 contractor? (For an explanation of W-2 and 1099, click Consultants: 1099 or W-2?) If so, what hourly pay rate would you need to at least match your salary?
When trying to decide the equivalent pay between being a Permanent/Salaried/Ful......
|
|