|
|
-
|
|
Yesterday night, I was reading Inside Microsoft Sql server 2008: Programming - Itzik Ben-Gen. On Cursors section Page number 291, he has tried to explain the scenario for calculating multiplication on row wise manner. He has explained through cursor. Be...
|
|
-
|
|
This will change the stored procedure from the username schema to the dbo schema
ALTER SCHEMA dbo TRANSFER [username].[usp_MyProcedure]
...
|
|
-
|
|
There's no way to return a resultset and set variables using a single SELECT statement.
But there's one way to do it using a MERGE statement.
It's quite simple, you first declare a variable table which will be used to store some data.
You then use a ME...
|
|
-
|
|
I just learned there is a difference between slicing and dicing in world of Data warehouse. Slicing refers to applying filters on a single dimension in a cube whereas dicing refers to applying filters on more than one dimension in a cube...
|
|
-
|
|
I just happen to change the Windows Server name on one of my Virtual machine - and I learned that the sharepoint stops working if you do so. To solve the error, you can refer to: ...
|
|
-
|
|
Today, while doing query or performance analysis, I wanted to start a profiler trace on the sql server in question. But since profiler generates network traffic I was looking for another approach. I learned that we can start the trace using system store...
|
|
-
|
|
Set the following properties on group for reset page number.
1. Select the grouping pane and hit F4 to show the Properties window for the Tablix.
2. Expand the Group and the PageBreak properties.
3. Change the value for BreakLocation to break for...
|
|
-
|
|
Community Technology Preview (CTP) 3 of the next version of SQL Server is available for public download and you can download it from http://technet.microsoft.com/en-gb/evalcenter/hh225126.aspx?wt.mc_id=nlc-f-us-Mba-TEC_93_1_7......
|
|
-
|
|
Just learned from Paul Randal's blog post that DBCC CHECKDB does not cause blocking. It used to cause blocking in SQL Server 7.0 and earlier versions, but never after that.
DBCC CHECKDB in SQL Server 2000 uses transaction log analysis to get a consis......
|
|
-
|
|
Both mean that an user could generate their own reports and they are shielded from underlying data infrastructure. This empowers end-users as they do not need to always ask IT for help..
A one-line statement about [powerview][1]: Delight users with an ...
|
|