In this issue

Featured Contents

Editorial

Featured Script

 
 advertisement
 
SQl Monitor "It really helped us isolate where we were experiencing a bottleneck"
- John Q Martin, SQL Server DBA. Get started with SQL Monitor today to solve tricky performance problems - download a free trial
 
SQL Source Control Is your SQL Database under Version Control?
SSMS plug-in SQL Source Control connects SVN, TFS, Git, Hg and all others to SQL Server. Learn more.
 
SQL Backup "Impressed is the word!
Cut our backup times in half and reduced the space used by 80%!" Tobie Dunn, SQL Backup Pro 7 user. See what savings you can achieve - download a free trial today.

In This Issue

Generate SSRS reports from a SSIS Package

Learn how to invoke SSRS reports from an SSIS package after the data load is completed. More »


Getting Started with the New Column Store Index of SQL Server 2012

Column Store Index, a new feature in SQL Server 2012, improves performance of data warehouse queries several folds. Arshad Ali shows you how to create column store index, and how to use index query hint to include or exclude a column store index. More »


Editorial - Why SQL Server is Better Than Oracle

Today's editorial was originally released on Oct 4, 2007. It is being re-run as Steve is out on the SQL in the City US 2012 tour.

WARNING: This editorial contains graphic language. Viewer discretion is advised.

I guess you can probably see this sentence if you can see the one above, but you've been warned.

Someone once told me when I was younger and playing sports that if you walk into the locker room and everyone calls you an a**hole, then you're surrounded by friends. If you walk into the locker room and no one says anything, you're the a**hole.

Over the course of my life I've remembered that quite often and I've noticed that the people I like and whose company I enjoy, I'll pick on, make fun of, joke with, and more. The people I don't like tend to get treated more formal and professional. And I've seen that in many places I've worked and even in social situations. You joke with those you like, or at least respect. And they joke back with you.

So, why is SQL Server better than Oracle?

That's easy. This is SQLServerCentral. Of course, SQL Server is better!

I tend to pick on Oracle more than other databases, mostly because Oracle has dominated the market share and space in the relational market for years. So in many ways they're an easy target. DB2 is up there, but it's not as much fun picking on them for some reason. Maybe because those mainframe guys with their tin foil hats won't listen or respond back :)

But they're a great product and I respect it, and so I pick on it a little. OK, so maybe more than a little, but it's all in fun. If I didn't think Oracle was a worthy competitor to SQL Server, I wouldn't even mention it. Notice that there are some other databases I don't really mention. That's kind of on purpose.

So if you're an Oracle user, and I know there's a few of you out there, don't get upset at the Oracle jokes. They're jokes. It's in fun.

Some of you are so uptight about your Oracle Parallelogram Server and the Really Ancient Cluster servers, and the Sesame Street Documentation. It's not as much fun picking on you when you get too upset.

Life is fun, and you should make every effort to ensure it stays that way. There's plenty of things that keep us serious and demand our attention without making more. Lighten up and fire your own joke back at me.

There's certainly plenty to pick on about me and SQL Server.


Everyday JonesThe Podcasting continues!

Send in some feedback and let us know what you think.

Music for today's Podcast from: Everyday Jones, All You Said was used in the stream.

» Join the debate, and respond to today's editorial on the forums

» To submit an article, rant or editorial, log in to the Contribution Center


Question of the Day

Today's Question:

In SQL Server 2008 R2 SP1 or SQL Server 2012, the auto updating of statistics rules are:

  1. Minimum threshold of 500 rows in the table.
  2. Fixed rate of change with a 20 percent threshold.
  3. Uses a default dynamic sample rate based on the # of rows. 

Is there a method / setting that will alter the fixed rate of change threshold ?

Think you know the answer? Click here, and find out if you are right.

This question is worth 2 points in this category: statistics. We keep track of your score to give you bragging rights against your peers.

We'd love to give you credit for your own question and answer. To submit a QOD, simply log in to Contribution Center.

Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks". Grab your copy today from Amazon.


Yesterday's Question of the Day

I set these

SET NUMERIC_ROUNDABORT OFF;SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT,QUOTED_IDENTIFIER, ANSI_NULLS ON;

I  then execute the following T-SQL

CREATE VIEW dbo.customer_view
  AS
 SELECT
   [CustomerID]
 , [FirstName]
 , [LastName]
 , [Priority]
 , [CreateDate]
  FROM [dbo].[Customer]
   GO

The view is created successfully. I then execute the following T-SQL

CREATE UNIQUE CLUSTERED INDEX IDX_V1
  ON dbo.customer_view ([FirstName],[LastName])

Is the unique clustered index created? 

Answer: No

Explanation: The index will not be created and you will receive this error:

Msg 1939, Level 16, State 1, Line 1
Cannot create index on view 'customer_view' because the view is not schema bound

Ref: http://msdn.microsoft.com/en-us/library/ms191432.aspx#Restrictions

» Discuss this question and answer on the forums

Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks". Grab your copy today from Amazon.


Featured Script

Tables, Queues, and Indices as a Percent of DB Size

Two views that give you a variety of stats, sortable as a percent of DB size, for tables, indiceses, XML indices, and Service Broker Queues. More »


Database Pros Who Need Your Help!

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2005 : Administering

SSRS 2005 report manager link not coming up - On my SQL Server 2005 installation. I am able to view the report server URL but I am unable to...

Is SQL Server 2005 Dev Edition still available? - Hi, I have SQL Server 2008 Dev Edition on my system, but I'm working with a client who's OLTP database still...

Differential backup failure - Hi Team, I am facing an issue with differential back up . The differential backup is failed only on sunday . we...

DBA Interview Questions needed - Serious only please. - Hi dudes and dudettes... The boss and I are conviced that we need a dba since the 3rd party firm providing...

SQL Server on Domain Controller - Hi friends Well, i have been told to never install a sql server instance on a windows server domain controller, but...

SQL Server 2005 : SQL Server 2005 Security

login permissions to run the SQL Server Profiler - Hi, Is there a way to grant a SQL Server 2005 login permissions to run the SQL Server Profiler without granting...

SQL Server 2005 : SQL Server 2005 Performance Tuning

CPU Usage, IO usage and memory usage for sql server 2005 - Hi, Which DMV can be used or is there any query which can give me an exact data about the CPU...

SQL Server 2005 : SQL Server 2005 Integration Services

SSIS Secure FTP Task - I am needing to transfer data using an encrypted tunnel. The only way I know of how to do this...

SQL Server 2005 : T-SQL (SS2K5)

STUFF & ISNULL - Hi, I'm new in SQL Server, i want the working process of STUFF & ISNULL. How it works & how it concatenate the...

How to join four tables using left outer join - Hi All, I want to show data from four tables on the basis of left outer join.All tables contain common column...

How to Build a single row with groups of fields from several rows per key - i have several rows like: Customer sn val1, val2, Val3 ..... (sn is a seq# from 1 to 15) A 1 31 54 A...

Merging rows - Hi All, Is it possible to combine two rows into a single row? example: [code="plain"]Asset ID Asset Name Relationship Company 1234 abcd Incident 1234...

CONVERT COLUMN VALUES TO COMMA SEPARATED ONE ROW VALUE.. - hi all... I have a query the returns country....state...and cities the cities are creating ore rows than required, I need to...

what is the difference between ODBC and OleDB? - Hi Friends what is the difference between ODBC and OleDB?

Find sub-tree nodes - Hi, I have a tree structure represented by a simple table that references itself: [code] CREATE TABLE [dbo].[AframeGroup] ( [GroupID] [int] IDENTITY (1, 1)...

SQL Server 7,2000 : T-SQL

determine if any error occurs in trigger from out of trigger - i have an Insert command on Table in which fires a trigger. i wanna know if any error occurs in...

SQL Server 2008 : SQL Server 2008 - General

A severe error occurred on the current command - Hi Everyone, I have a fairly simple query... it's sums a value from a single table and inner joins to a...

Can't Connect to Remote Server - Hi experts, 1. I have two servers. Server A and Server B. 2. They are located in two different places and connected...

Access Teradata from SQL server 2005 - We are trying to fetch Teradata tables in SQL server 2005. I installed OLEDB driver for Teradata on server hosting...

unable to start the sql service - when we are moving tempdb from d to f drive , files are successfully moved . when we tried to restart the...

SQL user test mail not working? - Hi, Mail session working fine with sysadmin user sa, etc after connect SQL user test mail seesion is not working. I try to...

restore log backups to another server - Hi every body I have a database in server A and i have a friday job that takes a full and...

compatible between sql server 2008 and sql server 2008r2 - hello all. I back up data base from sql server 2008r2 and i want to restor this back up in sql...

Memory utilization - SQL Server (2008) is using 92% of the memory. out of 56 GB SQL using 51.6 GB How to find out...

Derializer Report server Report Class 2012 ? - [b][u]serializer And Dserializer Rdlc File [/u][/b] [b]Report Class[u][/u][/b] name space >Microsoft.ReportingServices.ReportRendering Microsoft.ReportingServices.ProcessingCore.Dll (2012-06) [b]Testing....[u][/u][/b] > is false false= bool myBool = typeof(Report).IsSerializable; can't get ReportClass ..... like this...

Query Optimizer and value of local variable. - Let's take code example [url=http://www.sommarskog.se/query-plan-mysteries.html]from this[/url] article (part [i]Parameters and Variables[/i]): [code="sql"] CREATE PROCEDURE List_orders_1 AS SELECT * FROM Orders WHERE OrderDate >...

un split in sql - hello all. i use this function for split: ALTER FUNCTION dbo.GLB_Split(@String varchar(8000), @Delimiter char(1)) returns @temptable TABLE (id int identity(1,1),items varchar(8000))...

Need to fill the Gaps with previous value - Hi experts, I have a scenario to fill in the GAPS between the dates with previousdate+1 day. here is the table DDL...

Opening/Editing DTS in SQL 2008 - In Windows 2008 64bit server, even after installing Backward comp components, I could not open DTS in SQL 2008. I have...

Dying to solve this problem :-( "SINGLE QUOTATION" - it's only about ( SINGLE QUOTATION) in ASP.NET here is my SQL Query: [code="sql"]SELECT ID, Title FROM viewTopTitles WHERE Title = ' you're most welcome '[/code] but...

Clustered index, mandatory or optional?! - Hi, I'm reviewing our database tables and found some "bad" practices like Clustered index with Uniqueidentifier columns using NewId - support for...

Error With Query - I Have Two Table [b]Arazi[u][/u][/b] and [b]AraziEghdamat[u][/u][/b] and the Relationship between them is 1(Arazi) to Many(AraziEghdamat). i want to select all...

Using case in updating column - ok i have a table called "weights" that has following columns [code="other"] id shipweight1 shipweight2 shipweight3 [/code] Right now i have the following query [code="sql"] @id...

8 other pcs are connected through DSN, but.. - I have 8 pcs that are working off of the sql 2008 server, but have another pc that connecting on...

What would be the major concerns for running WCF services and xp_cmdshell on SQL Server? - All, The development group at my new company is using a WCF service running on the SQL Server to call a...

Calling Netbackup from SQL Job - Hi there, I am trying to initiate a Netbackup task from a SQL Job using the following CmdExec code: "C:\Program Files\VERITAS\NetBackup\bin\dbbackex.exe" -f...

A quick query puzzle: - Hi I have a table with below data. Requirement is to replace all integers with continous 6 or more occurances with...

Backup script - Hi, I'm using ola backup script and want to have all backups in the given backup directory NOT to create Instancename\databaseName\BackupType...

Query AD (Active Directory) - I know you can query AD for logins,email,location but if I want to know if the users are active or...

problem in displaying result from stored procedure to Frontend application - Hi I written a procedure to search hotel based on particular hotel name or based on a cityID. The procedure...

MDF and LDF locations - MDF and LDF in different locations make any sense in performance of SQL?

Using digital certificate - Hello, How to configure SQL Server engine to use digital certificate? Thanks in advance. Regards, Rohit Chitre

SQL Server 2008 : T-SQL (SS2K8)

Alphanumeric number generation - Hi, I need to write a SQL query to print the following aphanumberic sequence in SQL 2008. 0001, 0002, ... , 0009, 000A, ... , 000Z,...

Sql Server 2008 R2 Error: An error occurred while executing batch. Error message is: Error creating window handle. - Hi All, I'm running the query below in SSMS 2008 R2 and it takes longer than expected and when I...

Arithmetic overflow error converting numeric to data type numeric - Hi I have this code: SELECT [Policy_Id] = SNAP.POLICY_ID ,[Mex_Id] = FR.INV_PTF_NAME ,[Rebate_Amount_Gross] = ISNULL(CONVERT(DECIMAL(6,2),((FR.REBATE_RATE * SNAP.TOTAL_UNITS)/100)), 0.00) and I get this error: Arithmetic overflow error converting numeric to...

insert statements - multiple - I have build database script, and one part of them is to insert data, so I have multiple insert statements...

High CPU usage (Because of bad execution plan) - Hi everyone, We have a server, which has SQL SERVER 2008 R2,periodically we face with high CPU usage(100%) on this server.We...

BULK Insert zwischen Datenbanken - Hallo, ich lade mir einen Katalog (ca. 800.000 Datensätze) aus einer anderen, entfernten DB (über Verbindungsserver). Das Wiederherstellungsmodell steht auf FULL....

T-sql select - like - Hello, I'm new to these forums & need some help putting together a T-SQL query for selecting some info from my db....

Running out of Identity values - Ok Long story short, I am running out of Identity values on two tables (different databases) but very big tables, a...

SSMS Query Logging - We have a user who has come from an environment (SAS) where all of the queries she ran were logged,...

SQL Server 2008 : Working with Oracle

Linked server headaches - only failing when executed by sql server agent job - I have an Oracle 11g r2 linked server. Its currently working for queries and stored procedures. However, when attemping to...

SQL Server 2008 : SQL Server Newbies

null checking - I have one procedure with parameter @P. If @p= null & table abc has many rows with col1 = null, then following...

SQL query statement for copying data from different rows to different rows - I have a table (dbo.ACCOUNT_INF) with fields company_code (secondary key), accounts_code (unique) and other columns. I like to copy rows...

Script to find incorrect data in all tables - Our clients use MS-SQL 2000 through 2008, and soon will have some using 2012. WinXP through Win7, very few on Vista....

Transposing, filtering, most recent record - Hi all, A user at a PC help forum told me to try here. I have a SQL database with a lot...

Certifications for beginner - Hi ALL, I am currently working with SQL server 2005 database and would like to pursue certifications. From microsoft site, i...

Allways wondering why so many sql server programs are installed in my PC - Hello, I'm new to sql server and allways wondering why so many sql server programs are installed in my PC. As you...

UPDATE Does Nothing (Executing Query displays in status) - I am stumped and perplexed. The following statement executes correctly returns 2 Rows: [code="sql"]select JobNum, RefreshDate, RecID from ClosedJobsSumms[/code] [b]When this statement is...

Help reading Deadlock graph - I have been going through the forums on how to read this graph. I was asked where does a certain...

SQL Server 2008 : SQL Server 2008 High Availability

Sensible values for Database Mirroring Monitor Threshold - Hi all As the title suggests I am wondering what other people are using as thresholds for database mirroing. We have...

Changing Locations of DataFile - Hi All, As i see some of the servers are having databases online... Now this Database have data file & log file on...

SQL Server 2008 : SQL Server 2008 Administration

Service Broker - I am a newbie as far as service broker is concerned. The problem is with message forwarders. Forwarders are receiving...

DBA task for large production database - Hi, My production DB size is now 50Gb its increasing (sqlserver 2008 R2 Enterprice edition) Let me know the DBA task...

What is a read ? - Hi All When using DMV's to assess your SQL instance, what is a read? For example, when dealing with DMV's like: sys.dm_exec_query_stats sys.dm_exec_requests There are...

Query Memory Usage - Hi All I'm using the sys.dm_exec_requests to check what's happening in my instance There is a column called granted_query_memory, what does this...

import - export of dts package - Hi I am trying to import data from oracle to sql 2000 using dts package but unable to get all...

Scripts from SQL Domian Accounts - hi, i need sql script which will give the domain account services accounts should be used. Thanks Arjun

sql server Audit problem - Hi, I have created one database level audit to monitor select on table "Bet". This audit works only when principal name...

SQL express 2008 R2 - DB size - I am using express edition of SQL 2008 R2. As per the microsoft sites we can have max DB size...

Mgt Studio can see & login to other servers but not (local) - Built a new Windows 2008 R2 x64 server, and installed SQL Server 2008 on it, as a test version of...

Career : Certification

Need information about certification in Sql Server - Hi All, I have 3 year of Experience and I want to know which certification in sql server is good for...

Order of exams for MCSE - Just blasted through my 2008 BI exams and very much want to get straight into the 2012 exams. I am looking...

70-461 - Hi, Id like to take this exam and looking for some good prep.. My T-SQL skills are basic at present...

Career : Employers and Employees

Better to be a "jack of all trades" or a "master of one" with SQL? - Or will the answer be, as one of the speakers at SQL in the City put it, "it depends?" Right now,...

Career : Events

Maidenhead SQL Server User Group - [b]Maidenhead SQL Server User Group - Tuesday 27th March[u][/u][/b] Registrations are handled via [url=http://sqlserverfaq.com/default.aspx?EVTCTAG=Maidenhead]http://www.SQLServerFAQ.com[/url] Further details of future events can be found...

SQLServerCentral.com : Anything that is NOT about SQL!

Ryder Cup 2012 - So, the Ryder Cup's just started over at Medinah... Any golfing DBA's on here & will you be following the competition over...

Fantasy football 2012 - Only 2.5 short months to football, can you believe it? I'm not ready, hardly feels like it's summer time yet. You...

Talking baseball - Okay, a topic that has NOTHING to do with SQL . . . Came across [url=http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx]this link[/url] describing the SSC point scoring descriptions,...

Today's Random Word! - HI When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene...

Are the posted questions getting worse? - Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in...

Reporting Services : Reporting Services

[rsLookupOfInvalidExpressionDataType] !!? - Hi geniuses. I have a column in my report with an expression: =Lookup(Fields!ProjectGUID.Value,Fields!PROJ_UID.Value,Fields!STAGE_NAME.Value, "DataSet2") I'm not getting the right data. BIDS gives me a...

Customizing Reports Manager (SSRS 2008 R2) - All, I'd like to make some small cosmetic changes to my install of Reports Manager (SSRS 2008 R2). Maybe change the...

Performance issue with Multi value parameter in SSRS - Hi, I have a multi value parameter in SSRS report which has a list of values around 600..When the user selects...

Lookup Function. Have you tried it? - Hi geniuses! I'm stuck here with a Lookup function in SSRS. Can anybody give me an example of this function? Thanks Best Regards to...

Compare dates & Using Indicators - Hi geniuses! I need to compare dates (proj.last.publication (field) and current date) of various projects and depending of the result, expose...

Lookup - Hi All, Can someone help me with this problem? I have a table with product Id and another table with product...

SSRS/BIDS Indicators - I want to expose indicators based on a specific text, like "True" for example. If the value in the textbox is...

SSRS report error : Multi value parameter report error only with Select All - Hi, I have an issue to report paramters I have a report which group by data based on 2 paramters and also...

Reporting Services : Reporting Services 2005 Development

SSRS Dashboard-Passing Parameters in the same page - Hi All, I have to create a SSRS dashboard which would contain many reports in the dashboard main page. Say, I have...

Database Design : Design Ideas and Questions

Problem (doubt) with an Index on a composite key - [b]Can someone help me to clear this situation please, I have the tables shown below:[/b] [code="sql"] CREATE TABLE [dbo].[[b]Country.cat][/b]( [[b]Country_iD[/b]] [smallint] NOT NULL, [[b]FIPS[/b]]...

Data Warehousing : Integration Services

Dynamic file name for FTP task. - Hey I am also working on same task like this In SSIS ftp task... Here I created a variable for getting...

Pulling from public XML/API data sources for SSIS? - Hello all, I am in the process of building an experimental database for reporting purposes and would like to download...

SQL Server SSIS Package Configuration with sql server authentication not working - Hi! I am new to BI and i have a dilema. I created a data source with SQL Server Authentication(username:...

ssis data flow transform question - Hi I have one large table in one database and i am am going to move the data and turn it...

How to use same connection manager in different control flow tasks? - Task needed to complete: 1) Run sql task to set database to single user 2)Transfer sql server tables in a single database...