(Nelson John) In our earlier discussion about non clustered index ,we have seen that, the leaf level of a non clustered index contain only the non clustered index key column and clustered index key (if the table is a clustered table).
Tag: sql server
Improve SQL Server Analysis Services Performance with the Usage Based Optimization Wizard
(Daniel Calbimonte) Sometimes the SQL Server Analysis Services database query performance is slow and we need to improve performance. As a first step, I am assuming you have already created a partition to improve performance. In this tip I will demonstrate how to improve the query performance using
SQL SERVER – Fix – Error: 1060 The number of rows provided for a TOP or FETCH clauses row count parameter must be an integer
(Pinal Dave) Here is the interesting error one of my friend faced and it took me 15 minutes go over various code to identify the real issue. When we see a simple example in demonstration or a blog, we often think that SQL is a much simpler language and it looks easy.
How to Partition an existing SQL Server Table
(Ben Snaidero) I have read many articles on SQL Server partitioning and how to create a partitioned table, but I have an existing SQL Server database that has a few very large tables that could benefit from partitioning. What are the steps required to partition an already existing table?
How do I move a SQL login from one server to another without the password?
(Kenneth Fisher) This is an uncommon task but one that does turn up every once in awhile. A SQL login has to be moved from a development server to a test server, test to prod etc. Or maybe a lateral move to a new server.
Why is Count(*) Taking So Long
(Chris Yates) Phone rings……..I answer…….a DBA from a third party vendor has supplied someone with two scripts. The first script is a simple insert with a where clause:
Partitioning in SQL Server: Managing Sliding Window Scenario
(Arshad Ali) Earlier articles of this series discussed what partitioning in SQL Server is; the different kinds of partitioning options, why and when we should go for partitioning and the benefits a partitioned table/index provides.
How To Do Things That Scare You
Often times, to get ahead, you need to step out of your comfort-zone. Einstein has been quoted to say: “The definition of insanity is doing the same things over and over again; and expecting different results.” An ancillary thought is that “Doing the same things will keep you in the same place.” T
Elemental MDX: MDX Time Series Functions: PeriodsToDate() and OpeningPeriod(), Pt. 1
Elemental MDX: MDX Time Series Functions: PeriodsToDate() and OpeningPeriod(), Pt. 1 In this three-part article, we will introduce the PeriodsToDate() and OpeningPeriod() time series functions, which we can exploit to perform analysis within the context of time. As we have discussed in other articles of the Elemental MDX series, many business requirements revolve around theperformance of analysis within the context...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
SQL SERVER – Identify Last User Access of Table using T-SQL Script
(Pinal Dave) During the TechEd India 2013 presentations I received a question how to identify when any table is accessed by any of the user. It seems people would like to know if the table was used in any part of query by any user.