sql server

Un-Making a List (or Shredding of Evidence)
In my previous blog entry , I described in detail how you could use the FOR XML clause to create a column with a comma-separated list of entries acquired from rows in a table somewhere. In this article, we will do the opposite%26hellip; We will take a comma-separated list and %26ldquo;shred%26rdquo; the individual items into rows. Let's start by creating and populating a test table: create table #CSVLists ( ID int ,Description varchar(30) ,CSVList varchar(200) ) insert #CSVLists select 1,'Stoog

Blog Content

t-sql

SQL SERVER %26ndash; Recently Executed t-sql Query
About a year ago, I wrote blog post about SQL SERVER %26ndash; 2005 %26ndash; Last Ran Query %26ndash; Recently Ran Query .� Since, then I have received many question regarding how this is better than fn_get_sql() or DBCC INPUTBUFFER. The Short Answer in is both of them will be deprecated. Please refer to following update query to recently executed t-sql query on database. SELECT deqs.last_execution_time AS [Time] , dest. TEXT AS [Query] FROM sys.dm_exec_query_stats AS deqs CROSS APP

Blog Content

database administration

Aqua Data Studio 8.0 adds support for six more databases
by admin on October 15, 2009 AquaFold has launched a major upgrade to its database administration software, releasing Aqua Data Studio 8.0. The software is geared toward visualizing and working with multiple relational databases in a single view. Aqua Data Studio already supports Oracle, DB2 for iSeries, Microsoft SQL Server, MySQL, Sybase, Informix, apache Derby and PostgreSQL. Version 8.0 adds native support for new databases including Teradata, DB2 for z/OS, Sybase IQ 15 and nCluster.... Tag

Blog Content

sql server

Un-Making a List (or Shredding of Evidence)
In my previous blog entry , I described in detail how you could use the FOR XML clause to create a column with a comma-separated list of entries acquired from rows in a table somewhere. In this article, we will do the opposite%26hellip; We will take a comma-separated list and %26ldquo;shred%26rdquo; the individual items into rows. Let's start by creating and populating a test table: create table #CSVLists ( ID int ,Description varchar(30) ,CSVList varchar(200) ) insert #CSVLists select 1,'Stoog

Blog Content

ssas

SNESSUG September Meeting
We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and final, term. We were graced with the prescence of Jeff Moden, MVP and on of the top posters over at SQL Server Central . He was just visiting.�He's a great guy and I was very happy for the chance to meet him in person. Jeff is going to be at the PASS Summit this year, so you too can have a chance to meet him. The presentation was on ssas and SSRS by Sunil Kadimdiwan. He did a full int

Blog Content

sql server reporting services

%26ldquo;Client of JOB SOLUTIONS%26rdquo; recruits SR DBA sql
SR DBA sql Client of JOB SOLUTIONS Experience: 4 - 6 Years Location: Chandigarh, Mohali Compensation: Rupees 3,50,000 - 5,50,000 Education: UG - Any Graduate - Any Specialization,Graduation Not Required,B.Tech/B.E. - Any Specialization PG - Any PG Course - Any Specialization,Post Graduation Not Required Industry Type: IT-Software/ Software services Functional Area: Application Programming, Maintenance Job Description Design schemas. Build tables, FKs, PKs,Building queries, stored procedures,Eval

Blog Content

sql

Finish Wordpress Plugin
October 16th, 2009 Finish Wordpress PluginWe require modifications to an wordpress plugin.There is a fully functional existing version and a new version about 90% completed that requires finishing off.In addition you will create a new version of the plugin which will require you to change the name of the plugin and a few menus, and then to remove some functionality (it is a trial edition).The changes required are mostly cosmetic, but also there is some functionality in the old version which h

Blog Content

ssis

ssis: Archiving files with VB.Net
When creating ssis packages it's a common requirement to be able to archive the processed files. Here's VB.Net code snippet, with a quick walkthrough, that does exactly that. The script uses two variables, inFiles and archiveFiles . The variable inFiles contains the folder we want to move files from, and archiveFiles is the destination. Configure your variables in BIDS like below. Add a script task to the designer. Right click the script task, choose 'Edit'

Blog Content

ssrs

ssrs Performance Optimization and Analysis
Recently, I came across a very good article on ssrs Performance Analysis by Tom Mills using a tool called Fiddler . As the homepage of this tool states, "Fiddler is a Web Debugging Proxy which logs all HTTP(S) traffic between your computer and the Internet. Fiddler allows you to inspect all HTTP(S) traffic, set breakpoints, and "fiddle" with incoming or outgoing data. Fiddler includes a powerful event-based scripting subsystem, and can be extended using any .NET language." This article de

Blog Content

mssql

Integrate Optin Script
October 15th, 2009 Integrate Optin ScriptDear Freelancer,I have an Optin Script and an Optin Template.I Need to Integrate Optin Script to Optin Template.I Attached all Files.Payment Will be escrow. Thankyou. Regards, EsperanzaTradeSimilar JobsPhp Fox Expert WantedXml To mssql Db Script NeededVideo/picture Portfolio ScriptUpload ContentTroubleshoot Vb Script PageSwoopo Penny Auction CloneSimple Website To Be BuiltScript To Merge Csv DocsScript To Merge Csv DocsScript Installation Of TrafficScr

Blog Content

mssql

Integrate Optin Script
October 15th, 2009 Integrate Optin ScriptDear Freelancer,I have an Optin Script and an Optin Template.I Need to Integrate Optin Script to Optin Template.I Attached all Files.Payment Will be escrow. Thankyou. Regards, EsperanzaTradeSimilar JobsPhp Fox Expert WantedXml To mssql Db Script NeededVideo/picture Portfolio ScriptUpload ContentTroubleshoot Vb Script PageSwoopo Penny Auction CloneSimple Website To Be BuiltScript To Merge Csv DocsScript To Merge Csv DocsScript Installation Of TrafficScr

Blog Content

ssas

SNESSUG September Meeting
We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and final, term. We were graced with the prescence of Jeff Moden, MVP and on of the top posters over at SQL Server Central . He was just visiting.�He's a great guy and I was very happy for the chance to meet him in person. Jeff is going to be at the PASS Summit this year, so you too can have a chance to meet him. The presentation was on ssas and SSRS by Sunil Kadimdiwan. He did a full int

Blog Content

sql server

What Is Using The Most Space In Your Database ?
As I work on moving a large system with multiple database servers from a 27TB SAN to a single database server with about 6TB of direct attached storage (DAS), I have to worry much more about space utilization. The stakes are also a little higher, since it is much harder to add space with DAS than with a modern SAN. There are several aspects to this problem, such as how large are your data files, how full are they, and how large are your database backup files. Within a database, you need to be

Blog Content

database administration

Oracle Certification Releases Live Exam: 1Z0-053 %26ldquo;Oracle database 11g: administration�II%26rdquo;
The new %26ldquo;Oracle database 11g: administration II%26rdquo; certification exam is now live in production. This new exam (1Z0-053) is a single exam requirement for those holding the Oracle database 11g Administrator Certified Associate (OCA) to earn to Oracle Certified Professional (OCP).Candidates can register now for the live exam, which is available at Pearson VUE testing centers worldwide with immediate scoring and pass/fail status. Candidates who participated in the beta can expect to receive your beta

Blog Content

mssql

Which version of MS SQL is supported?
Gossimer currently supports MS SQL Server 2005 %26ndash; 9.00.1399.06 (X64) Developer Edition (64-bit).

Blog Content

sql server reporting services

Unhandled Exception, Error while switching panels, SSRS, sql server 2005 reporting services
I tried to add reporting services today to my existing sql server 2005 instance on Windows 7. I installed it successfully however upon first run I faced an Unhandled Exception in WMI Component. Also when I clicked server Status or any other option it said unable to switch panels WMI error again. Well upon googling it for a while I found nothing useful and thought to dig it myself. I came to the conclusion that there must be some difference between Service packs. I queried my server and found tha

Blog Content

sql

Create An Ea Using Ichimoku
I'm using a forex strategies with 57.1% of success rate in manual trading so far. To eliminate the bad trades I would like to create an EA to check the trading conditions with 80% probability. I'm using Ichimoku indicator signals, 3 EMAs,traditional MACD cross overs with Fractals. I've tried to simplify the explanations. If you need further assistance please contact me. I've attached some screen shots and Ichimoku tutorials as well. =================================================== PRE CO

Blog Content

t-sql

SQL SERVER %26ndash; Comic Slow Query %26ndash; SQL Joke
Community TechDays at Ahmedabad was a great successful event. In fact, this can be considered the biggest event held in Ahmedabad thus far along with the community. I have posted a detail report of the same at SQLAuthority News %26ndash; Community TechDays in Ahmedabad %26ndash; A Successful Event . After the event, I received many emails requesting the comic strip I had shown in my presentation. I had presented two different comic strips: one before the presentation and the other after the presentation. B

Blog Content

ssrs

SNESSUG September Meeting
We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and final, term. We were graced with the prescence of Jeff Moden, MVP and on of the top posters over at SQL Server Central . He was just visiting.�He's a great guy and I was very happy for the chance to meet him in person. Jeff is going to be at the PASS Summit this year, so you too can have a chance to meet him. The presentation was on SSAS and ssrs by Sunil Kadimdiwan. He did a full int

Blog Content

ssis

Dew Drop %26ndash; October 11, 2009
� Jump to: .NET / Visual Studio | Web Development | Design / Methodology / Testing | Silverlight / WPF | Podcasts / Screencasts / Videos | Community / Events | Database | Miscellaneous | More Link Collections | Book of the Day � .NET / Visual Studio Zune HD Level Program Written in XNA (John O'Donnell) Beware Uri.ToString and � Did FxCop tell you to use System.Uri? (Keith Brown) Mono, open source and Azure (Louis Salin) T4 Toolbox: Support for Visual

Blog Content

mssql

How do I Upgrade my MS SQL 2000 database to MS SQL 2005?
Follow the below mentioned instructions to upgrade your existing MS SQL 2000 database to MS SQL 2005: Take a backup of the current database. Click here to know how to make a backup copy of your db >> � Delete the database that you have just backed-up from your Gossimer Control Panel. Click here to know how to Delete your database >> � Add the MS SQL 2005 database from your Gossimer Control Panel. Click here to know how to Add a

Blog Content

database administration

Where Can I Find The database administration Option On Wordpress?
Question %26ndash; I have a blog on wordpress and I have to do this: Log in to your hosting account and from the control panel locate database administration. But I can'tsee the database admistration option.Where is it?Under what option? Related posts:Building Your Website With Wordpress (part 1)How Do I Update A Wordpress Account Installed With Fantastico?Moving Your WordPress (...continued) Related posts: Building Your Website With Wordpress (part 1) How Do I Update A Wordpress Account Instal

Blog Content

t-sql

SQLAuthority News %26ndash; Accessing SQL Server Databases with PHP
The SQL Server 2005 Driver for PHP is a Microsoft-supported extension of PHP 5 that provides data access to SQL Server 2005 and SQL Server 2008. The extension provides a procedural interface for accessing data in all editions of SQL Server 2005 and SQL Server 2008. The SQL Server 2005 Driver for PHP API provides a comprehensive data access solution from PHP, and includes support for many features including Windows Authentication, transactions, parameter binding, streaming, metadata access, conne

Blog Content

t-sql

SQLAuthority News %26ndash; Accessing SQL Server Databases with PHP
The SQL Server 2005 Driver for PHP is a Microsoft-supported extension of PHP 5 that provides data access to SQL Server 2005 and SQL Server 2008. The extension provides a procedural interface for accessing data in all editions of SQL Server 2005 and SQL Server 2008. The SQL Server 2005 Driver for PHP API provides a comprehensive data access solution from PHP, and includes support for many features including Windows Authentication, transactions, parameter binding, streaming, metadata access, conne

Blog Content

ssrs

SNESSUG September Meeting
We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and final, term. We were graced with the prescence of Jeff Moden, MVP and on of the top posters over at SQL Server Central . He was just visiting.�He's a great guy and I was very happy for the chance to meet him in person. Jeff is going to be at the PASS Summit this year, so you too can have a chance to meet him. The presentation was on SSAS and ssrs by Sunil Kadimdiwan. He did a full int

Blog Content

sql server integration services

Range-Lookups mit den integration services %26ndash; Teil I
In den von uns gebauten integration services Paketen ist der Lookup der wohl am meisten genutzte Task und im Grunde macht er seine Arbeit auch meistens gut und schnell. Sp�testens wenn man w�hrend des ETLs jedoch fortlaufende Werte wie z.B. das Einkommen eines Kunden in Gruppen �bersetzen will, st��t man mit dem Lookup an seine Grenzen. Diese Artikel-Reihe beschreibt zwei Workarounds, mit denen sich dieses Problem mit dem Lookup trotzdem bew�ltigen l�sst und schl�gt zum Schluss eine wesentlich p

Blog Content

sql

Dolphin Boonex Site
October 9th, 2009 Dolphin Boonex Site have a site up needs work to be completed Similar JobsInstall Dolphin Boonex ScriptInstall Dolphin Boonex ScriptDolphin Boonex ProgrammerDolphin Boonex ProgrammerDolphin Boonex ProgrammerDolphin Boonex CustomizationDolphin Boonex Authorize.netCustomize Boonex Dolphin SiteViral Video SubmitterTraffic To Escort SiteSocial Network Due In 24 HoursSocial Bookmarking 10�10x200Simple Monthly Data EntrySimple Backlink GenerationSeo Traffic %26 Link BuildingSeo Pr

Blog Content

ssis

09 ott Carta d'identit�: TFA � Universit� Categoria: Insegnamento
Riguarda tutti coloro che in Italia vogliono intraprendere la carriera di insegnanti e al contrario della morta e sepolta ssis, scuola di specializzazione per l' insegnamento secondario, adesso il TFA eviter� il precariato, %26hellip;Fonte Articolo:Carta d'identit�: TFA � Universit�

Blog Content

sql server

What a backed up Database Mirror looks like
One thing you need to be careful about with sql server 2005/2008 Database Mirroring is making sure that you don't exceed the I/O capacity of the storage subsystem of the sql server instance where the mirrored database lives. If you do this with High Safety mode (synchronous) mirroring, your applications will be slowed down, waiting on the mirror. This usually happens when you do something that generates an unusual amount of log activity (such as index creation or maintenance, or shrinking a d

Blog Content

sql server reporting services

Unhandled Exception, Error while switching panels, SSRS, sql server 2005 reporting services
I tried to add reporting services today to my existing sql server 2005 instance on Windows 7. I installed it successfully however upon first run I faced an Unhandled Exception in WMI Component. Also when I clicked server Status or any other option it said unable to switch panels WMI error again. Well upon googling it for a while I found nothing useful and thought to dig it myself. I came to the conclusion that there must be some difference between Service packs. I queried my server and found tha

Blog Content

t-sql

SQL SERVER %26ndash; Queries Waiting for Memory Allocation to Execute
In one of the recent projects, I was asked to create a report of queries that are waiting for memory allocation. The reason was that we were doubtful regarding whether the memory was sufficient for the application. The following query can be useful in similar case. Queries that do not have to wait on a memory grant will not appear in the resultset of following query. SELECT�TEXT , query_plan , requested_memory_kb , granted_memory_kb , used_memory_kb , wait_order FROM sys.dm

Blog Content

t-sql

SQL SERVER %26ndash; Queries Waiting for Memory Allocation to Execute
In one of the recent projects, I was asked to create a report of queries that are waiting for memory allocation. The reason was that we were doubtful regarding whether the memory was sufficient for the application. The following query can be useful in similar case. Queries that do not have to wait on a memory grant will not appear in the resultset of following query. SELECT�TEXT , query_plan , requested_memory_kb , granted_memory_kb , used_memory_kb , wait_order FROM sys.dm

Blog Content

sql

How to change Min/Max Memory in sql Server?
Step 1: Open SSMS Step 2: Connect to desire Server and right click on the server (for i.e. sqldbpool) and Select properties � Step 3: Click on memory tab and configure Min and Max memory

Blog Content

ssas

SERIE DM Excel %26ndash; Parte 4: %26ldquo;Highlight Exceptions%26rdquo;
Bueno, en esta parte de la serie de miner�a de datos desde Excel 2007 les muestro un video donde uso la caracter�stica %26ldquo;Highlight Exceptions%26rdquo;, muy �til para encontrar informaci�n an�mala en un conjunto de datos. Podr�n ver que esta herramienta es m�s poderosa de lo que uno se imaginar�a, pues uno podr�a definir f�cilmente que tan exigente debe ser para determinar que un dato es an�malo, entre otras cosas. Les recomiendo ver este video, pues esta caracter�stica les puede ser muy �til y c�mo s

Blog Content

ssis

Data Transformation Services vs. ssis: The key differences
I recently published an article on� SearchSQLServer.com about� DTS and ssis where I talk about some of the differences .� Obvsiolly I didn't cover all the differences between DTS and ssis, just some of them.� So don't go railing on me that I didn't cover something. Denny

Blog Content

ssrs

Dew Drop %26ndash; October 7, 2009
� Jump to: .NET / Visual Studio | Web Development | Design / Methodology / Testing | Silverlight / WPF | Podcasts / Screencasts / Videos | Community / Events | Database | SharePoint | Miscellaneous | More Link Collections | Book of the Day � .NET / Visual Studio Imaginet and Telerik Introduce Free Team Workload Management Tools (Charles Sterling) Extending the Entity Framework Provider Model to support DDL (Alex James) Lightweight Debugging for Hybrid C#

Blog Content

sql server reporting services

Reordering the Table position in SSRS
New Question Created by UmaD

Blog Content

sql server integration services

Range-Lookups mit den integration services %26ndash; Teil I
In den von uns gebauten integration services Paketen ist der Lookup der wohl am meisten genutzte Task und im Grunde macht er seine Arbeit auch meistens gut und schnell. Sp�testens wenn man w�hrend des ETLs jedoch fortlaufende Werte wie z.B. das Einkommen eines Kunden in Gruppen �bersetzen will, st��t man mit dem Lookup an seine Grenzen. Diese Artikel-Reihe beschreibt zwei Workarounds, mit denen sich dieses Problem mit dem Lookup trotzdem bew�ltigen l�sst und schl�gt zum Schluss eine wesentlich p

Blog Content

sql server

sql server string join
Today our dev team asked the question "Is there a way to join strings in sql server from a table output?" Immediately the DBA and I said yea concatenate. Well while that may be possible this might be an easier way. At first I though that using a select @var = @var + text would not concatenate across the table but it does. Ex. declare @blah table (text varchar(max)); insert into @blah values ('a'); insert into @blah values ('b'); insert into @blah values ('c'); insert into @blah values ('

Blog Content

sql server reporting services

Reordering the Table position in SSRS
New Question Created by UmaD

Blog Content

t-sql

SQL SERVER %26ndash; Interesting Observation %26ndash; Query Hint %26ndash; FORCE ORDER
SQL Server never stops to amaze me. As regular readers of this blog already know that besides conducting corporate training, I work on large-scale projects on query optimizations and server tuning projects. In one of the recent projects, I have noticed that a Junior Database Developer used the query hint Force Order; when I asked for details, I found out that the basic concept was not properly understood by him. Today, let us try to understand its working and the effect of this hint. Further,

Blog Content

sql server integration services

Range-Lookups mit den integration services %26ndash; Teil I
In den von uns gebauten integration services Paketen ist der Lookup der wohl am meisten genutzte Task und im Grunde macht er seine Arbeit auch meistens gut und schnell. Sp�testens wenn man w�hrend des ETLs jedoch fortlaufende Werte wie z.B. das Einkommen eines Kunden in Gruppen �bersetzen will, st��t man mit dem Lookup an seine Grenzen. Diese Artikel-Reihe beschreibt zwei Workarounds, mit denen sich dieses Problem mit dem Lookup trotzdem bew�ltigen l�sst und schl�gt zum Schluss eine wesentlich p

Blog Content

mssql

Sugarcrm Email %26 Modules
October 5th, 2009 Sugarcrm Email %26 ModulesI need email automation setup for sugarCRM and custom modules set up. Here is the detail for this job: 1. i will only look at you response if you put your astrological sign in the subject line %26ndash; (there is too many responses from people that don't even bother reading these specs %26ndash; this is an attempt to cut down on this %26ndash; I don't actually care what sign you are 2. The mail automation i need is: when a contact is entered OR imported i need that to trigg

Blog Content

sql

Private Project for SICS (SalesMaker) by skyeso
Fix SalesMaker as we discussed. (Budget: $30-250, Jobs: PHP, sql)Originally posted here:Private Project for SICS (SalesMaker) by skyesoPosted in Latest Projects.Tagged with description, freelance, messages-posted, outsource, php, project, provider-rating, sql. Byadmin%26ndash;October 5, 2009

Blog Content

ssas

Software Database Engineer SQL Server BI SSRS SSIS ssas
WA Redmond, Software Database Engineer SQL Server, BI, SSRS, SSIS, ssas Description: Software Database Engineer Database Design T SQL, Business Intelligence SSIS, SSRS, ssas, SQL Server PerformancePoint and SharePoint We are looking for a talented, motivated, self starting individual to work on fast paced Business Intelligence projects for a support group for a variety of console, handheld and PC video game

Blog Content

ssrs

SQL Developer Anblicks Virginia Beach VA
SQL,ssrs,SSIS,DTS,Stored Procedures,Health Care experience,Triggers, REQUIRED Need 8+ years of experience. Strong in communication Strong experience in SQL... From Dice 03 Oct 2009 08:10:13 GMT save job, email, more...

Blog Content

ssis

SQL Programmer Info Technologies United States
Windows, Oracle, and SQL technology. As DCA continues... and maintaining SQL code SQL, T SQL, DTS, and ssis packages, OLAP and Data Marts in a Microsoft SQL... From Info Technologies 03 Oct 2009 05:18:06 GMT save job, email, more...

Blog Content

sql server

AppDev %26ndash; LINQ Using Visual C# 2008
AppDev %26ndash; LINQ Using %26ndash; Visual C Sharp 2008 DVD-iNKiSO | 1.3Gb In this course, you'll learn to use the exciting new .NET Framework 3.5 feature, Language Integrated Query (LINQ) to easily create complex data-independent queries. In addition, you'll learn about the new language features added to Visual C# in Visual Studio 2008 in order to [...] Related posts: AppDev sql server 2008 Installing Querying Security DVD AppDev ASP.NET Using Visual Basic 2008 Vol.1%262 AppDev Exploring Microsof

Blog Content

database administration

Navicat Premium 8.2.14
Navicat Premium is regarded as a easy-to-use as substantially as multipurpose multi-connections database administration agency that is created to earmark you to enter to MySQL, PostgreSQL and Oracle databases simultaneously within a azygos application, making database brass to binary kinds of database.Read original story of :http://wareseeker.com/Software-Development/navicat-premium-8.2.14.zip/3bea8c15bb Navicat Premium 8.2.14Tags: administration, connections database, database, databa

Blog Content

mssql

Cookie Unique Session Id
A cookie is already set up on website. It is downloaded when user logs in for the first time. 1. Give the existing cookie a unique session ID when it is first downloaded. 2. Every time the user revisits the website, and is already logged in or logs in, update the same cookie on their machine with a new unique session ID. Log the new unique session ID in the customer table on the database. Revisiting the website means visiting any of these pages: http://www.bankinggrapevine.com/default.asp h

Blog Content

sql

dbExpress driver for sql Server 4.55
dbExpress utility for MS sql Server (DbxSda) provides admittance to MS sql Server database. It entireness using broad action Microsoft OLE DB technologies. DbxSda supports MS sql Server 2005, sql Server 2000 and sql Server 7.Read original story of :http://wareseeker.com/Software-Development/dbexpress-driver-for-sql-server-4.55.zip/7d6478172 dbExpress driver for sql Server 4.55Tags: Access, DbxSda, driver, ms sql server, Server, sql, sql server 2000, sql server 2005, sql server 7, sql s

Blog Content

sql server integration services

Range-Lookups mit den integration services %26ndash; Teil I
In den von uns gebauten integration services Paketen ist der Lookup der wohl am meisten genutzte Task und im Grunde macht er seine Arbeit auch meistens gut und schnell. Sp�testens wenn man w�hrend des ETLs jedoch fortlaufende Werte wie z.B. das Einkommen eines Kunden in Gruppen �bersetzen will, st��t man mit dem Lookup an seine Grenzen. Diese Artikel-Reihe beschreibt zwei Workarounds, mit denen sich dieses Problem mit dem Lookup trotzdem bew�ltigen l�sst und schl�gt zum Schluss eine wesentlich p

Blog Content

ssrs

Reporting Services (ssrs/MSRS) 2008 Error: Set used with the complement operator must have all members from the same level
When you use the Not In operator in a ssrs 2008 MDX query filter to exclude a named set, it uses a the complement operator in the constructed MDX. This is fine as long as "all members [are] from the same level." Since you got this error, they are not You can get around this by using the Except() MDX function instead of letting ssrs use the Complement operator In the ReportServerService log, you'll see something like this: Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseExcept

Blog Content

ssas

Kerberos SPN Generation Setup Tool %26ndash; Common Tab
The last post %26ldquo; Kerberos SPN Generation Setup Tool %26ndash; Documentation, Instructions %26rdquo; gave a review of where to find help basically in the form of %26ldquo;Online Documentation%26rdquo; and the %26ldquo;Instructions tab%26rdquo;.� This is a continuation of the series of blog posts %26ldquo; Kerberos SPN Generation / Setup Tool %26rdquo; that describe how to use the Kerberos SPN Generation Setup Tool Beta for Kerberos Constrained Delegation with Microsoft BI tools.� This post covers the first Input section tab %26ndash; the %26ldquo;Common tab%26rdquo;.� You can downl

Blog Content

ssis

Odio freddo su Israel
Odifreddi, il Matematico impertinente , fresco prepensionato dell'Universit� di Torino come ha rivelato Campus , non ne vuol sapere di godersi il suo buen retiro dedicandosi alla sua attivit� di divulgatore scientifico. Giorni addietro, ha messo il cappello anche sulla polemica Israel , quella montata nei contro il docente della Sapienza, reo di aver guidato il tavolo tecnico ministeriale che ha lavorato alla riforma delle ssis , le scuole di formazione degli insegnanti.� Polemica che,

Blog Content

database administration

uCertify 1Z0-053 OCP: Oracle database 11 8.01.05
PrepKit OCP 1Z0-053, OCP: Oracle database 11g: administration II is an mutual code covering that helps you learn, tracks your progress, identifies areas for improvements and simulates theRead original story of :http://wareseeker.com/Home-Education/ucertify-1z0-053-ocp-oracle-database-11-8.01.05.zip/6c61b6eb0 uCertify 1Z0-053 OCP: Oracle database 11 8.01.05Tags: administration, database, improvements, interactive software application, OCP, oracle, oracle database, PrepKituCertify 1Z0-05

Blog Content

sql server reporting services

AppDev.Microsoft.sql.server.2008.Analysis.services.SSAS.DVD-iNKiSO
AppDev Microsoft sql server 2008 Analysis services SSAS DVD-iNKiSO ENG | ISO | 980Mb In this course, you will learn how to use Microsoft sql server 2008 Analysis services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes, cube storage and aggregation designs to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices [...] Related posts: AppDev ASP.NET Using Visual Basic 2008 Volume 2 DVD-iNKiSO AppDev sql server 2008 Ins

Blog Content

sql server

Customized test feed for SSP
Related Posts New SSP Blogger: John SansomSqueaking in just before Thursday's contest deadline comes our newest... sql server %26ndash; Difference between Line Feed (\n) and Carriage Return (\r) %26ndash; T-sql New Line CharToday, we will examine something very simple and very generic... Test post for MybloglogUndergoing MyBlogLog Verification... 71-450 Beta Test ReviewI wrote this test today. It was not bad. Some... Dev, Test and Production sql server environmentsFellow DBA Jason Crider asked me about my idea

Blog Content

t-sql

SQL SERVER %26ndash; SQL Server Management Studio and Client Statistics
Client Statistics is very important. Many a time, people relate queries execution plan with query cost. This is not a good comparison. Both are different parameters, and they are not always related. It is possible that the query cost of any statement is less, but the amount of the data returned is considerably large, which is causing any query to run slow. How do we know if any query is retrieving a large amount data or very little data? In one way, it is quite easy to figure this out by just lo

Blog Content