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: SQL 2008
73 results found
Exploring Row and Page Compression with
SQL 2008
- Part 1: The research
Our application runs on SQL 2005 and so we are looking at the upgrade path to SQL 2008 and even SQL 2008 R2. This application has been installed at over 20 locations (clients) and they all have thier own installation and environment for SQL Server. In ord
Author:
bretupdegraff
Date: 12/13/2009 Section:
Blog
tags :
SQL 2008
,
Compression
How to move the tables without having clustered index from one file group to another file group simply in
SQL 2008
.?
Hello All, This might not be the proper for the blog post but it helps me to understand more regarding the transfer of tables within different file groups in MS-SQL. So, I think it will be more helpful to the others who indeed needs such information relat
Author:
Anil
Date: 1/18/2012 Section:
Blog
tags :
File groups FG's
,
T-SQL
Why doesn’t my Intellisense work?
After yesterdays’ webinar, we got a lot of great feedback and questions. Once of the more common questions was around intellisense, getting it to work and why some folks don’t have it, even though they are running SQL 2008. The trick here is, you need to
Author:
AdamJorgensen
Date: 2/23/2010 Section:
Blog
tags :
Intellisense
,
SQL Options
,
SQL Server
Parent/Child Help
You've got a few options with SSIS. You could "do the work" in T-SQL as an execute SQL task. One method would be modifying something like what is shown here: http://www.sqlservercentral.com/scripts/Miscellaneous/31913/ - I'd use a regular table instead of
Author:
KeithHyer
Date: 5/17/2011 Section:
Forum
tags :
pivot
,
script task destination
,
delimited string
SQL Server 2008 r2 login
Looks like I've botched installation of SQL 2008 r2 I installed for SharePoint Server 2010. I tried to follow least-privileges guidelines for SharePoint and not sure where I made mistake. I had 3 accounts: spsqlsvc - I used as sercvice account for SQL Ser
Author:
mdexch
Date: 5/18/2011 Section:
Forum
tags :
sharepoint 2010
,
SQL 2008 R2 installation
SSIS Data Flow task not running, but not failing
Apologies for the ambiguous title, but was unsure how to headline this query. Windows Server 2008 (x86) with SQL Server 2008, posted images of the task operational details are below, but first a summary of the issue. I have a very straightforward data flo
Author:
user730460
Date: 11/29/2011 Section:
Forum
tags :
ADO.Net
,
data flow performance
,
ODBC
,
PI WADIS
Upgrade SQL/SSRS 2008R2 to 2012 SP1 SSRS Excel Rendering Issue
I'm testing upgrading SQL/SSRS from SQL 2008 R2 SP2 to SQL 2012 SP1 (11.0.3349). Most of my reports' data source is a Dynamics NAV 2009R2 SQL DB where most of the number fields are decimal(38,20). I'm finding that when I have a zero value in a column on a
Author:
tkruse
Date: 3/20/2013 Section:
Forum
tags :
excel 2010
,
render
,
SSRS 2012
,
upgrade
,
xml errors
SQL Saturday Tampa 2011- The Aftermath
Well it was a great SQL Saturday in Tampa and we all learned and networked alot. In my session with Aaron Nelson "SQL Smackdown" we compared powershell and SSIS. You can download a copy of the packages here . These packages are SQL 2008 In Iron Chef Devin
Author:
MikeDavis
Date: 1/18/2011 Section:
Blog
tags :
Iron Chef
,
Powershell
,
SQL Smackdown
,
SSIS
,
SQL Saturday
SQL R2 Map Change map type, Road, Aerial, Hybrid
With the new Map control in SQL 2008 R2 there are three different map types, Road, Aerial, and Hybrid. If you want to allow your users to change the map type you would think you could map a parameter to the property on the tile layer with these three type
Author:
MikeDavis
Date: 8/6/2010 Section:
Blog
tags :
Aerial
,
Hybrid
,
Map
,
Road
,
SSRS
SSIS Expressions And 4,000 Character Limit (2/3)
In Part 1 of this blog posting I demonstrated how a combination of SSIS package configurations and expressions can make your ETL process dynamic. In this posting I am going to discuss the dreaded 4000 character limitation in expressions for SQL 2008R2 (an
Author:
CraigLove
Date: 1/16/2012 Section:
Blog
tags :
Package Configurations
,
SQL Server
,
SQL Server Integration Services
Repeating Column Headers in SSRS 2008 and R2
This blog is more of an FYI because it’s not a new issue just something I thought needed to be shared here on bidn. Quickly after SQL 2008 was launched SSRS developers soon found out that SSRS had a few bugs. The one in particular that seems to be the mos
Author:
ChrisAlbrektson
Date: 8/10/2010 Section:
Blog
tags :
SSRS
,
Repeating Column Headers
Orphaned Users for Sql Server Databases
A customer of ours is using one of our products to document their sql environment. The problem they were having was they were able to document everything except for 2 specific databases. There environment is SQL 2008R2. They have the DBO permissions to bo
Author:
SMcDonald
Date: 7/7/2010 Section:
Blog
tags :
pragmatic works
,
Property Owner is not available for Database
,
This property
,
Orphaned Database User
xp_readerrorlog for SQL AgentLog failing with no column information in
SQL 2008
R2
I have an SSIS package written in visual studio 2008 that was installed with sql 2008 R2. I have a data flow task in a foreach loop to change the server name that is stored in a table in sql which I have verified is working to bring back the correct serve
Author:
lculley2012
Date: 4/19/2012 Section:
Forum
SQL Server 2008 R2 Developer Installation
Anyone else run into this? I'm installing a development / testing VM in Virtual PC 2007 and when attempting to install SQL 2008 R2 ( developer - from MSDN ) under Win XP SP3 ( fully patched ) - otherwise, a clean install, I get the following error: "Insta
Author:
KeithHyer
Date: 7/26/2010 Section:
Forum
tags :
error
,
Installation
,
setup
SSRS Report Model Forms Authentication for Web Access and model filtering
We have clients wishing to build custom reports on their data.Is there a way where we can give them a web forms to authenticate (like our current web app uses e.g User Table including Username and password) which will then pass the username to the report
Author:
wesdev
Date: 26 days ago Section:
Forum
tags :
custome security
,
report model
,
ssrs
Documenting Your SSRS Reports and Data Sources
If the organizations you've worked with are anything like the ones I've had the pleasure of working with, then they probably had or have thousands of SSRS reports spread out all over the place. And back around the time a majority of companies were gearing
Author:
DustinRyan
Date: 11/10/2011 Section:
Blog
tags :
BI Documenter
,
document sql server
Problem Using the Aggregate Function with Calculated Measures
Recently, I was working with a client we were working on a calculated measure using the aggregate function to rollup a periodstodate calculation using a calculated measure. The value repeatedly returned null, but when I used SUM it worked fine. This appea
Author:
AdamJorgensen
Date: 2/21/2010 Section:
Blog
tags :
KB
,
MDX
,
SSAS
DBA Question of the Day: What Changes have occurred to DBCC CHECKDB in SQL 2012?
Changes made to DBCC CHECKDB that are included by default in SQL 2012
Author:
SQLBalls
Date: 8/24/2012 Section:
Article
tags :
CHECKDB
,
SQL 2012
,
SQL Internals
Reference the Previous Record in a Data Set
In a recent project I've been tackling for the last couple months, I've been migrating several significant subsystems into a single larger system. In one of the tables I'm populating, there is a field for the previous ticket ID, but in the source table th
Author:
DustinRyan
Date: 7/12/2010 Section:
Blog
tags :
reference previous record
,
ROW_NUMBER
,
Common Table Expression
Smooth Compound Operators
Ok, so I can’t promise you’ll be smooth by the end of this entry, but I can promise you’ll be compound operating like a champ. In SQL 2008 there is a new feature called .. you guessed it … Compound Operator. What Microsoft means by this is they have imple
Author:
AdamJorgensen
Date: 11/3/2009 Section:
Blog
tags :
Compound Operators
,
T-SQL
ROW_NUMBER() Function and Creating a Row ID on the Fly
The ROW_NUMBER() function is a great function that was added with the release of SQL 2005 and is also included in SQL 2008. ROW_NUMBER makes it very easy to number your rows across the entire data set or across partitions of your data. Here are a couple e
Author:
DustinRyan
Date: 6/16/2010 Section:
Blog
tags :
create ID for each row
,
ROW_NUMBER() function
Adding a folder to the SSIS Package Store
The SSIS Package Store is a nice option to available for storing SSIS packages. The Package Store list packages stored on the server in the MSDB folder and all packages stored on the file system as long as they are in the default folder (C:\Program Files\
Author:
DevinKnight
Date: 11/7/2009 Section:
Blog
tags :
SSIS
Dynamic Lookup and Fuzzy Lookup or alternative
There is no way to do this using transformation. If you intend to use SQL 2008 R2, you can do that using script task and the use newly introduced Fuzzy Lookup functions. Refer this blog post for the functions dscribed above.
Author:
nitya
Date: 12/21/2009 Section:
Forum
tags :
fuzzy lookup
How to complete uninstall SQL Server 2008 R2 Nov CTP ?
Hello all, Firstly what I want to say that after finishing the trial version or evaluation period. I try to uninstall the current instance of Sql 2008R2 and thinking to install again another instance of trial period. Can we uninstall the installed instanc
Author:
Anil
Date: 1/19/2011 Section:
Forum
tags :
SQL
,
SQL 2008 R2 installation
Access OLEDB Connection Manager from ScriptTask to Execute SQL Commands
Sometimes you may need to access OLEDB Connection Manager to execute Queries in Script Task. This article will explain you how you can do that using a very simple script.
Author:
NayanPatel
Date: 11/24/2009 Section:
Article
tags :
SSIS OLEDB Connection Manager Script Task
Page 1 of 3 (73 items)
<< Prev
1
2
3
Next >>
Go to page:
[Go]