|
|
-
|
|
Yesterday I saw a question about required permission for changing SQL Server login password and I decided to write a blog post about it. Question was: I have a SQL logins: Login1 and Login2. I gave ALTER LOGIN permission on Login1 to Login2 so that Login2 can change the password for Login1. But when......
|
|
-
|
|
In SSAS, data structures do not always conform to the snowflake or star schema model where one fact is associated with a single dimension member. For example, consider the example of financial transactions in accounts that can have one or more customers. This can be modeled as:
The relationship ......
|
|
-
|
|
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......
|
|
-
|
|
In SSAS, to improve query performance, it’s important to understand what happens inside analysis services when a query is run. Analysis Services is made up of two engines:
Formula Engine (FE) – It is single-threaded. It processes the MDX queries, determines what data is needed to answer the......
|
|
-
|
|
Working with multiple databases on multiple instances is a tough job. You need to monitor all these instances for everything. Best way to keep eye on every instance activity is SQL Server Jobs. How fastly databases on these instances are growing and does t...
|
|
-
|
|
LOGBUFFER is one among the IO Wait types in SQL server. This wait type is one of the very rare wait type. As I described earlier, it has got relation with WRITELOG. Just to iterate the same, please look at the operations when transaction happens(also look at the WRITELOG wait type explanation.(http:......
|
|
-
|
|
You can browse available SQL Instances on network by choosing "" from Server Name drop-down list in "Connect to Server" dialog box in Management Studio:
As you can see from the screen shot, all of my instances are visible on the network. If I want to hide this information fro......
|
|
-
|
|
I hear you. You’ll use the Execute Package Task. This mechanism of executing one package from another is popularly knows as Parent Child paradigm. Let me tell you, this isn’t new in 2012. There are, however, a few changes to the Execute Package Task. Let’s...
|
|
-
|
|
As you may know, the TechEd in the U.S. is not the only one. There have been many all over the world, and it 2011 there have been one’s in New Zealand, Australia, and next month in Russia. The Australia and New Zealand TechEd ended a couple of months ago, and all the videos from those sessio......
|
|
-
|
|
If you’ve been working with databases for any length of time, you have heard the term normalization.
Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in ......
|
|