Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: Useful
169 results found
GROUP BY WITH ROLLUP
The ROLLUP operator is useful when summarizing data. Its useful when generating reports that contain subtotals and totals. I use it a lot in my audit/daily queries, because table/matrix/tablix has subtotals. Basically ROLLUP generates a result set that sh
Author:
marcoadf
Date: 2/7/2010 Section:
Blog
tags :
FIFA
,
ROLLUP
,
subtotal
,
total
,
WITH ROLLUP
,
GROUP BY
tutorial....
have you heard about rsscripter? I was able to move reports, subscriptions and so on from 2005 to 2008. You might find RS Scripter particularly useful for: - quickly and easily extracting all RDLs from a report server - generating scripts to load reports,
Author:
marcoadf
Date: 2/17/2012 Section:
Forum
tags :
migrate
,
migration
,
move
,
reporting
,
rscripter
,
Subscriptions
Useful
queries #3: Get SQL Server Edition, Version, Build and Last Update date and time.
Keeping track of all the versions and editions SQL Server instances can be a daunting task if you don?t have the right tools and documentation. A very easy way to obtain version, edition and build information from your SQL Servers is by querying the SERVE
Author:
JoseChinchilla_SQLJoe
Date: 10/11/2011 Section:
Blog
tags :
build
,
cumulative
,
edition
,
editions
,
service pack
,
SQL Server
,
update
Subscriptions: How to manage them
Hi. This is my very 1st blog share. I'm here to talk about subscriptions and how to manage them, either manually or automatically. I will show you how to see all information from existing subscriptions (like last run status, last run time, who created, wh
Author:
marcoadf
Date: 1/16/2010 Section:
Blog
tags :
active subscriptions
,
manage subscriptions
,
re
,
Reporting Services
,
run subscriptions
,
Subscriptions
Multiply and Divide a group of cells in Excel
I just now realised that it has been more than a month since I have posted anything on my blog. So here I am with the most recent tip I learnt in Excel. If you have a column of cells that need to be divided by 1000 for example. Here are the steps that you
Author:
indupriya
Date: 12/4/2011 Section:
Blog
tags :
add
,
divide
,
Microsoft Excel
,
Multiply
,
Paste Special
,
subtract a group of cells.
SSIS Package Development Troubleshooting Tips
When developing an SSIS package, sometimes it can be frustrating trying to troubleshoot various issues and faults with the package. And if you're not a seasoned SSIS developer, you may not be sure about the best way to solve your problem. Thankfully, Micr
Author:
DustinRyan
Date: 5/28/2010 Section:
Blog
tags :
Data viewer
,
debug window
,
Troubleshoot SSIS package
Using BCP Utility in SSIS
The Bulk Copy Program Utility (BCP) is a very nifty little command line tool that allows us to bulk copy SQL Server data from or to a data file in a user specified format. The BCP is very useful when you need to copy large amounts of data into a data file
Author:
DustinRyan
Date: 5/11/2011 Section:
Blog
tags :
BCP
,
Bulk Copy Program
,
SSIS BCP out
SSIS Package Design Help
aeolus, Sounds like a challenging package you've picked to start with! It also looks like in one project, you have the opportunity to learn several useful features in SSIS. [ok, stepping down off the soap box] Don't worry if you don't know how to set all
Author:
KeithHyer
Date: 7/5/2011 Section:
Forum
tags :
variables
,
data driven
,
expressions
,
for each loop
,
ssis
SSRS: Information about reports ran
Some times is very useful to gather information about report execution, for example: How often a report is requested Report duration time (slowest reports) User that ran more reports What formats are used the most This information can be achieved from Exe
Author:
marcoadf
Date: 4/6/2010 Section:
Blog
tags :
ExecutionLog
,
reports ran
,
reportserver
,
slowest reports
,
ssrs
Free Training Webinar - Maximizing the Data Exploration Capabilities of Power View
Pragmatic Works hosts FREE live demos every Tues & Thurs @ 11 am EST. SQL Server, SharePoint, PowerPivot and Business Intelligence topics from Microsoft MVP's and industry experts. Join Melissa Coates for Free Training on the T's and support W.I.T. (W
Author:
MWatts
Date: 3/27/2013 Section:
Blog
tags :
apabilities
,
ata exploration
,
harepoint
,
Power View
,
xcel 2013
Terminology Differences between Team Foundation Server and Subversion
I've been knee deep in Team Foundation Server 2010 reading and found a useful table describing the Terminology differences between Apache Subversion and Team Foundation Server. Not all the credit is mine, I got the list of differences from Wrox Profession
Author:
Tyler
Date: 9/12/2011 Section:
Blog
tags :
2010
,
foundation
,
Server
,
Subversion
,
Team
SSIS Data Types
For all of its life, there have always been a lot of questions circulating around about data types in SSIS. What does an int in SQL map to in SSIS? What about a varchar? nvarchar? The questions could just go on and on. But, finally, we have an answer. In
Author:
ChrisSchmidt
Date: 12/27/2012 Section:
Blog
tags :
data types
,
ssis
,
SSIS 2012
,
ssis data types
SSIS: DTS duration (outside) & display it on Project
Hi. Sometime is very useful to know DTSs duration. In big DWs, we often get performance issues. Just for example, in one of my datamarts I have more than 110 DTS packages running each day. And with that information I can focus where to improve. I have 2 w
Author:
marcoadf
Date: 1/29/2010 Section:
Blog
tags :
DTS
,
Duration
,
Project
,
SSIS
SSRS dataset fields disappear when using a stored procedure with dynamic SQL – How to get them back and save your report
Every once in a while I write some dynamic SQL for a stored procedure that I am using for several different reports. Pros and Cons of dynamic SQL aside, this is a very useful technique in some circumstances. However from time to time if you use dynamic SQ
Author:
Daniel
Date: 6/16/2011 Section:
Blog
tags :
Dynamic SQL
,
Fields disappear
,
Fields Missing
,
SSRS
Data Quality Services Best Practices
Microsoft recently released the Data Quality Services Performance Best Practices White Paper (get it HERE ) and there is a bunch of useful information to both be aware of and to take into consider when planning your implementation of DQS. This post is bas
Author:
cprice1979
Date: 3/12/2012 Section:
Blog
tags :
White Papers
SSIS Expressions And 4,000 Character Limit (1/3)
This blog post was originally going to be a quick hit on a technique used to overcome the 4,000 character limitation of expressions. This limitation will go away in SQL Server 2012. However, since some many of us will continue to work with older versions
Author:
CraigLove
Date: 1/5/2012 Section:
Blog
tags :
Package Configurations
,
SQL Server
,
SQL Server Integration Services
Task Factory's: Terminator Destination
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugg
Author:
briankmcdonald
Date: 9/3/2011 Section:
Blog
tags :
Brian K McDonald
,
task factory
,
Terminator Destination
Build Configurations in SSIS 2012
Although not new in SSIS 2012, Build Configurations have become exponentially more useful with the introduction of parameters and the new project deployment model. Before we dive in to see how useful this feature is, let's take a moment to review paramete
Author:
cprice1979
Date: 3/6/2012 Section:
Blog
tags :
Tips and tricks
,
Visual Studio 2010
Free Poster! Guide to SQL Server Isolation Levels
While goggling about SQL Server Isolation Levels found the useful poster from Kendra Little (One of the Presenter from 24 Hours of Pass ) . Have look and post it in your desk if it is useful to you. Poster Link
Author:
meganathank
Date: 3/16/2011 Section:
Blog
tags :
Poster
,
SQL Server Isolation Levels
SQL Bits Content
I came across this link on SQL Bits where there are about 164 videos on various aspects of SQL Server and sharepoint which I found useful. Altogether there are 215 articles. Have a look at the compiled sessions and content page . Hope you also find this c
Author:
indupriya
Date: 1/25/2011 Section:
Blog
tags :
SQL Bits Sessions and Content
,
SQL Bits
Redgate’s Free SQL Search Tool
I have been using this tool for quite a while and just remembered that I haven’t written a blog about it! I believe it to be an extremely useful tool for anyone who uses SQL Server Management Studio (SSMS) and it is a must have for any hard core DBA or Da
Author:
briankmcdonald
Date: 2/15/2011 Section:
Blog
tags :
Brian K McDonald
,
SQL Search
,
SQL Server Tool
,
Redgate
Quickly Edit Package Configuration Values from BIDS
If you've followed my blog at least somewhat, you've probably read a blog post or two where I cover one or several of the really cool features of BI xPress . That's because, simply put, BI xPress is a very versatile and useful tool that no SSIS developer
Author:
DustinRyan
Date: 10/31/2011 Section:
Blog
tags :
BI xPress
,
SSIS Package Configurations
Document your SSIS Packages with BI Documenter Part3: Comparing Snapshots
In the last two posts we?ve discussed how to use BI Documenter to document your SSIS packages and reviewed the documents that is generated. Another one of the very useful features of BI Documenter is the Snapshot Comparison. Let us suppose that you have s
Author:
TomLannen
Date: 12/1/2011 Section:
Blog
tags :
3rd Party Documentation
,
BI Documenter
,
SSIS Documentation
Tips for using the BIDN forums
I really have not posted much in the way of blogs on here lately. I've been putting together what I'm hoping will be a useful ( and free ) .PDF that you ( as a BIDN user ) will be able to pass on to people you meet that helps them get set up and familiar
Author:
KeithHyer
Date: 6/29/2011 Section:
Blog
tags :
forum etiquette
,
HOWTO
,
tips-n-tricks
,
BIDN
LookUp and LookUpSet Functions New in SSRS 2008 R2
With the release of R2 came a couple of pretty nifty new expressions in SSRS. The LookUp function allows us to perform a look up against a separate data set in our report using a field in our source data set where there is a 1 to 1 relationship. Likewise,
Author:
DustinRyan
Date: 7/27/2011 Section:
Blog
tags :
Join function
,
LookUp function
,
LookUpSet function
,
SSRS 2008 R2
Page 1 of 7 (169 items)
<< Prev
1
2
3
4
5
6
7
Next >>
Go to page:
[Go]