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