SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

Featured Script

The Voice of the DBA

Managers

Most of us have managers that are picked from the ranks of our technical staff. Often the most talented technical person, or most willing technical staff member, is promoted to manager, given a few hours of training on the various tools that he or she will use to deal with the administrative paperwork a manager fills out, and then cut loose to "manage" a group of people.

And they stink at it.

Most of them are bad. Not only are they bad managers, they are often bad leaders, and many find their technical skills suffer as they split their time with managerial tasks. That certainly puts them in a bad mood and creates worry about their future. It's not even just in the technology industry, as we find that many managers are bad, yet still languish on for years. This despite the fact that research shows they are costing their companies profit.

Personally I think we are still evolving from the factory-like mentalities where managers needed to oversee workers and give them little leeway or choice in how they perform their jobs. Even in "knowledge work" or creative endeavors, managers too often feel the need to "do something" when they could often do less and get more accomplished. A big part of this is managers want to be paid more because they are responsible for people doing work. However they often don't accomplish more than their subordinates.

I doubt much will change, but I'd like to see managers for technical people (and directors even) paid less than their technical people, with less responsibility over workers' efforts. Help them get delays, issues, and problems not related to their tasks out of the way and let them get work done.

Steve Jones from SQLServerCentral.com

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


The Voice of the DBA Podcast

Listen to the MP3 Audio ( 2.0MB) podcast or subscribe to the feed at iTunes and LibSyn. feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

Everyday Jones

Follow Steve Jones on Twitter to find links and database related items and announcements.

ADVERTISEMENT
45 tips for database devs free ebook

FREE eBook "45 Database Performance Tips for Developers"

Improve your database performance with 45 tips from SQL Server MVPs and industry experts. Get the free eBook here.

SQL Monitor

Get alerts within 15 seconds of SQL Server issues

SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

SQL Data Compare

Compare and synchronize database contents

“I've been really missing a neat data comparison tool - SQL Data Compare Pro seems to be the answer to my prayers.” Jan Hansen, Database Architect. Download a free trial.

Featured Contents

 

Stairway to PowerPivot and DAX - Level 1: Getting Started with PowerPivot and DAX

Bill Pearson from SQLServerCentral.com

Learning DAX is easy once you install the PowerPivot for Excel 2010 add-in and get practical exposure to using functions, operators and values in DAX formulas. Bill Pearson, business intelligence architect and author, kicks off another Stairway series designed to get you using DAX and PowerPivot quickly to provide actionable business intelligence in your own environment. More »


 

Free eBook: SQL Server Backup and Restore

Press Release from Red-Gate

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool. More »


 

12 SQL Server XML Questions You Were Too Shy To Ask

Additional Articles from SimpleTalk

Robert Sheldon answers 12 questions about XML, including situations you would want to use XML, and how to do basic tasks. More »


 

From the SQLServerCentral Blogs - Logistics For All Day Meetings

Andy Warren from SQLServerCentral Blogs

Quick thoughts about the work required to make all day meetings run smoothly: Suitable space with enough seating (and reasonable chairs!)Turn... More »

Question of the Day

Today's Question (by Steve Jones):

How do you remove a memory-optimized table filegroup from your database in SQL Server 2014?

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


We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Administration.

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

ADVERTISEMENT

Securing SQL Server - Written by Denny Cherry, a Microsoft MVP for the SQL Server product, a Microsoft Certified Master for SQL Server 2008, and one of the biggest names in SQL Server today, Securing SQL Server, Second Edition explores the potential attack vectors someone can use to break into your SQL Server database as well as how to protect your database from these attacks. In this book, you will learn how to properly secure your database from both internal and external threats using best practices and specific tricks the author uses in his role as an independent consultant while working on some of the largest and most complex SQL Server installations in the world. This edition includes new chapters on Analysis Services, Reporting Services, and Storage Area Network Security.

Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Andy Warren):

Pop quiz hot shot - say you're on a bus going 50 miles per hour when the driver asks you for the ranges of the exact number data types in SQL Server. Your eyes glaze, who can remember that stuff? He says, ok hotshot, how about this - tell me the smallest exact number integer data type that can't support a negative number and I'll stop the bus and buy you breakfast.

Can you answer the question, stop the bus, and have a nice omelette?

Note - don't worry about the spelling/abbreviation used for the data types in the answers.

Answer: TinyInt

Explanation:

There are four data types that are integer/exact number: bigint, int, smallint, and tiny int. The ranges of those can be found here http://technet.microsoft.com/en-us/library/ms187745.aspx. The only one that doesn't support a negative number is tinyint.

I wasn't able to find a reference for why that is, just guesses that it was because Ascii is 0 to 255. Integers can be signed or unsigned (see more here http://en.wikipedia.org/wiki/Integer_(computer_science)). In practice tinyint is often used for lookup tables where the range of values will be very small - often much less than the 256 possible.

"Pop quiz hot shot" is a quote from the movie Speed, here's a clip of it: http://www.youtube.com/watch?v=Ug2hLQv6WeY. The title of the question is a distant take on Tiny Bubbles (in my mind) by Don Ho - surely you want to sing along right? Here you go! http://www.youtube.com/watch?v=mlCiDEXuxxA


» Discuss this question and answer on the forums

Featured Script

Size of database files for an instance of SQL Server

Andrés Michaca from SQLServerCentral.com

Size of database files for an instance of SQL Server

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 2014 : Administration - SQL Server 2014

log shipping with read only mode? - Hi experts, we are about to start a logshipping with the secondary server in read only mode. I just wanted to...

AlwaysOn - use an Availability group listner or just point to the Cluster name - I have MasterDataServices installed on a server and the database is in an AlwaysOn Availability Group. The MDM front end currently...

SQL Server 2014 - Service Pack 1? - Hi there I am planning to migrate from SQL2008R2 --> SQL2014 but my team mates have concerns about migration of MS...

Read only on secondary Replica - Assume if i have a connection(Application intent readonly) starts with reading, writing and again reading data for a report. how...


SQL Server 2014 : Development - SQL Server 2014

Can you count columns from sys.partition table, if not is select count(1) the fastest way ? - Can you count columns from a variation of the following query ? set statistics time on SELECT OBJECT_SCHEMA_NAME(object_id) as dbo ,OBJECT_NAME(object_id) as rows ,SUM(Rows) AS...

Selecting Records Based on Date - So let's say I have a table Orders with columns: Order# and ReceiptDate. Order#'s may be duplicated (Could have same...


SQL Server 2012 : SQL 2012 - General

get view definition using SQL_Modules with linebreaks so that different lines can be inserted as different records into a table - SELECT [DEFINITION] FROM SYS.SQL_MODULES WHERE [OBJECT_ID] = OBJECT_ID(@OBJECTNAME) I know I can use SP_HELPTEXT to get linebreaks, The reason I want to use...

msdb.dbo.sp_send_dbmail - DECLARE @tab char(1) = CHAR(9) DECLARE @Localquery VARCHAR(MAX) SET @Localquery = 'SELECT SOME STUFF' EXEC msdb.dbo.sp_send_dbmail @recipients = 'xxxx.yyyyyyy@zzzzz.qqqq', @query = @Localquery, @subject = 'Pending IBS Updates', @attach_query_result_as_file...

Changing Availability Group - Hi Experts, How can we change the backup replica in Always on Cluster. I am not able to take backup because...

Msg 6517, Level 16, State 1, Line 1 error on database integrity - Hello all, i m getting this on the beginning of DBCC CheckDB Failed to create AppDomain "master.sys[runtime].349". Exception has been...

login/user cannot execute or see stored procedures - We are using a third party tool that does not store passwords in an encrypted format therefore we created a...

Assign create stored procedure permissions - Only to a specific schema? Can this be done? Thanks, DK

reporting services would not send subsciption emais - Hi, I am running RS 2012 installation and everything worked until few days ago. Now the subscriptions would not even run....

How to create a SQL 2012 Failover cluster using VMs? - Hi thanks before everything!, I have the following question that I hope you can oriented me: How to create a SQL...

Pull the string inside the stored procedure definition - In the below procedure definition, i need to find a way parse the definition and get the list of places...

many to many relationship - Hi, why do we need a junction table in a many to many relationship? Why can't everything be in just...

SQL 2012 AlwaysOn Group Configuraiton Issue. - Dear Gurus, Hope all is well. i am confronting one error while configuring the SQL 2012 AlwaysOn Group after the...

Disk Space required for Express edition engine vs Developer - We have a debate in my dev team on what edition of SQL should be installed on a VM template...

SQL Agent Jobs showing NO history - Hi - We migrated to SQL 2012 and now a few SQL Jobs don't seem to have job history (and I...

Differences between SQL 2012 AND SQL 2008R2 - Can anyone expalin the Differences between SQL 2012 AND SQL 2008R2 ?


SQL Server 2012 : SQL Server 2012 - T-SQL

Is there any database setting that affects CHECKIDENT(RESEED) - Greetings, all. I am using CHECKIDENT(RESEED) in a Visual Studio 2013 script that clears numerous test data tables & repopulates them afresh,...

Disable only one trigger action - I have a trigger that executes AFTER INSERT, UPDATE, DELETE. Is there a way to disable and then reenable only...

Querying XML from SSMS - Hi, I have an xml document that (for this example) I've simplified to look like this: <xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882' xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882' xmlns:rs='urn:schemas-microsoft-com:rowset' xmlns:z='#RowsetSchema'> <s:Schema id='RowsetSchema'> <s:ElementType name='row' content='eltOnly' rs:updatable='true'> <s:

How to find this year and past year compare in business - We have customers who are new to this year (2014) and there same customers in last year (2013). also there...

complicated sql syntax - looking for explanation for working query - About six months ago, one of the regular SSC forum experts gave me this query to use to build a...

Help!!! - I need help in creating a temporary table where I can log the QueryName, StartTime, Endtime, Duration and run the...


SQL Server 2008 : SQL Server 2008 - General

Investigating deletes from a table - Hi! This is my first post here, but I'm a longtime reader. I'm investigating who or what is deleting records from...

SSRS -- Error while subscribing for new role - Hi all, I'm getting below error while subscribing for new role in SSRS. System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report...

SSIS caching error - I am running a pretty straight forward dataflow that is: Source -> Lookup -> Destination I am in the process of trying...

Generate script for clr functions - Hi, Please I want a script that create all CLR functions (with its assemblies) for a specific Database Thank you.

Creating a trigger if the DB is down? - I was trying to log into one of our DB and found out that it had been down since Sunday...

IsDate function to filter bad dates. thanks - we are migrating ms access 2007 databases to sql server 2008r2 and we are getting invalid data format error in...

Audit when using Service accounts - We have an application, which is configured to run under service account. It connects to database using service account. The application...

Duplicate Object_ID and rows ...etc - Hi friends, When I run select * from sys.Partitions, output comes out with object_id (with 3-4 same object id no. some time...

Rebuild jobs crashes the DB server - Hi Experts, We have a SQL Server 2008 Standard edition, 8 CPU & 24 GB RAM. Yesterday I created a maintenance job to...

Move and rename a file in SSIS - Iam able to move a file in SSIS File System task but for renaming ,should I need to add another...

index - Hello, does somebody know query for result about index where procedure or query use this index ?

TSQL dilemma - I have a table with an identifying field that is duplicated. I want to get a single record for this...

How to Script Creation of Multiple Stored Procedures - I have about 50 Stored Procs and UDFs that need to be created in a test database each time the...

Error when view design table - I have noticed in my error log below error when i view design table : what should i do to correct...

SSIS data conversion error - Iam using flat file source,data conversion and oledb destination for data transfer But Iam getting the error [BEM(ETA) [161]] Error: SSIS Error...

SQL Server Read ismore - Insert into Table Select * from anothertable where somecondition in(select some_condition from thirdtable) While doing this operation i see there are more reads...

difference between # and ## temp tables in sql server - hello please tell me difference between # and ## temp tables in sql server as per my knowledge # temp table is only for that...


SQL Server 2008 : T-SQL (SS2K8)

Select One of Three Values that are Not NULL - Hello Everyone I hope that you are having a very nice day. I am working on some data that is JOINing to...

Could this be done using PIVOT ? - I have 2 identical tables one contains current settings, the other contains all historical settings. I could create a union view...

Generate working schedules - Hi, Hope someone can help me with this: I would like to generate a working schedule for employees for x-days ahead based...

problem in logic for finding a Recursive Cte - hi, hope everybody doing good, here is my problem this is my data [code] DECLARE @Tbl AS TABLE (Mainid INT, Referenceid INT) INSERT INTO...

Max with distinct two columns and corresponding third column - Hi, i need to write a query and can't get it to work no matter how it try. Here's what...

Turning raw data into a grid layout - Hi all, not sure how best to explain what I'm trying to do so will try to break it down as...

comparison in the merge statement about null values - I use the merge statement in a sproc to insert, update and delete records from a staging table to a...

Store result of stored procedure into a xml/nvarchar(max) variable - I have a stored procedure that returns XML using FOR XML Explicit. I need to use the output of this...


SQL Server 2008 : SQL Server Newbies

Moving Queries for access to SQL - For the most part this is pretty easy once you know where to put things, but what if the query...

Slow self join - I have a stored procedure which updates a table with the code below. It is rather slow (table with 360,000 rows)....

More Memory - We have a Sql Server running Server 2003 Std X64 SP2, On this we have a Microsoft SQL Server 2008...


SQL Server 2008 : SQL Server 2008 High Availability

How to delete service and add in MS cluster - How Can I "uninstall " SSAS service from MS cluster and re-install it back so that when I can isolate the...

Cluster resource 'SQL Server' failed - While troubleshooting why a query failed on our SQL Server 2005 cluster, I note in the SQL Server log that...

Mirroring - Intermittent "network name is no longer available" - Is this a network issue? I have a mirroring setup - synchronous with automatic failover. The databases went into Disconnected mode...


SQL Server 2008 : SQL Server 2008 Administration

Rebuild Index Task Failed - Dear All, I have Created a maintenance plan for Rebuild Index on my database. But after executing that Task it is throwing...

Interview Questions for a Developer - What type of SQL Database questions would you ask of a prospective junior PHP web developer. We know he is...

BAckup's not completing 100% - I have a monthly full backup job in my prod instance serverinstance1. It runs fine and gives me a successful...


SQL Server 2008 : SQL Server 2008 Performance Tuning

Queries for per database performance - I'm trying to get a handle per-database performance on my servers (SQL 2005 and 2008 R2) to determine candidates for...


SQL Server 2005 : Data Corruption

Backup failed but DBCC CHECKDB has no errors - SQL 2008 R2 Database. Backup failed with this message: BACKUP 'Db' detected an error on page (1:24909497) in file 'D:\Data\Db.mdf'. Msg 3013,...


SQL Server 2005 : SQL Server 2005 General Discussion

Failed to notify ''operator name'' via email? - Following command sends email fine: EXECUTE msdb.dbo.sp_notify_operator @name=N'operator name',@body=N'test message' However, SQL Job with a notification to above operator doesn't work. Job history...


SQL Server 2005 : SQL Server 2005 Integration Services

(SSIS 2012) - Develop on 32-bit machine, Install on 64-bit machine confusion - I'm developing a comprehensive SSIS solution for a client. Development is being done on a virtual machine (VMWare) that's a...

Update of two tables at the same time - Hi @ ALL before i explain my problem, below situation at the moment i have a simple data flow task, with a OLE...

Problem parsing expression - I'm trying to create an expression for a flat file connector connection string. I'm in SSIS 2008. here's the code: "G:\Operations\DATA\SSIS\AST\"...


SQL Server 2005 : T-SQL (SS2K5)

Inserting binary string at an offset to exsting data in a Text type field - Good morning, I am supporting an application which stores Geometry values in tables for use with Spatialware this was before SQL...


Reporting Services : Reporting Services

Multi Valued Parameter - I am trying to run a Multivalue parameters Report I set the Parameter type as Multi Valued In my Query I...

When Multiple values are selected it gives an error incorrect syntax near ',' - Hi , I have a report which works fine with single value parameter but when I select multiple values I get...

Join 3 sharepoint lists - In my SSRS report I am using data from three SharePoint lists. I used the Lookup function to get data...

Grouping of distinct values for column - Hi, I am creating a drilldown report. My datasets are coming from several SharePoint lists. My first column has alternating...

Sound - Is there a way to generate a Sound in SSRS. I need to do so when a particular criteria is not...


Reporting Services : Reporting Services 2005 Administration

Site Settings and Security Tabs are missing from Reports Manager link - To the SQL forum readers. From our SQL server 2005 Reporting Server page the tabs for Security and Site Settings are missing....


Reporting Services : Reporting Services 2005 Development

Grouping features in report table, BIDS 2005 - Hello, sorry for the extreme noob question, but here goes.... I am doing a simple Labor Cost Analysis in the table...


Reporting Services : Reporting Services 2008 Development

ssrs keep objects (textboxes) in fixed location - In an exisitng SSRS 2008 r2 report there are currently 5 tablixes. Right now in one of the tablixes, I...

SSRS List with a permanent group value - Afternoon. I am trying to create a list in SSRS that retains a permanent group value. I created my data...

ssrs 2008 tablix should be invisible - In an SSRS 2008 r2 report, I have an existing report that if the grade level is from 01 to...

SSRS 2008R@_Reporting Services: Got an error message "Timeout expired" when doing "Request Fields" for a stored procedure. - Hello BI experts, I have successfully ran the sp on SSMS and got the results(about 30 thousands records) and it's fine....


Data Warehousing : Integration Services

Problem reading via OleDB provider for MS Directory Services - Hi, I was asked to get information from AD. I have a connection of type: OleDB provider for MS Directory Services and the...

SQL SSIS to Oracle CLOB Performance Issue.. - Hi I'm attempting to push data from SQL via SSIS DT_TEXT to an oracle CLOB field, but performance is utterly horrendous....


Data Warehousing : Strategies and Ideas

How to store a central repository of data - I am fairly new to database design and haven't been able to find a lot on this question. I work for...

Difficulty flipping from relational modeling to dimensional modeling - Im building my first star schema Order fact table with Product, retailer. date and customer dimensions so that's fine. im finding it...


Database Design : Disaster Recovery

Database Restore Testing Documentation - I test my database backups about once a month, on average. My question is, I am in need of a...

Compare DR solution using hardware level like Storage function and Software level like log shipping or database mirroring.. - I am a storage admin. I have a project about comparing between DR solution. In the original my company use...


SQLServerCentral.com : Articles Requested

Grant create procedure (and view) permissions to a schema - An article showing how to separate developers and allow them to create objects in a schema, but only that schema. Base...

Poor Man (dev) Version Control - There is a way to create a version control within the database without the need of third party tools. It...

Execute SQL Queries Across Multiple Servers - Was wondering if i can blog on this 'Execute SQL Queries Across Multiple Servers'

Utilizing dbWarden and ApexSQL Log to monitor a 2008R2 Standard database - Hello -- I took on the responsibility of finding a way to determine if changes were made to a particular database...

Consolidated Dates Queries - I have seen a few questions about how to get the first, last days of the month, year, etc. Can...

Is an Index Being Used? - I am looking for a short piece that queries the DMVs to show which indexes are being used by your...

Building Natively compiled stored procedures in SQL 2014 - Why, how, what purposes and restrictions.

CONNECT ANY DATABASE Permission - This is new in 2014. What this means, how it works, and potential downfalls.

Resource Governor 2014 - How this works in 2014 with the new IO controls.

Writeable columnstore indexes - An article that shows how these work. This needs a good example scenario that shows how performance is improved.

Create data files in Azure - Show how to set up an Azure account for hosting data files and then creating them with an on-premises SQL...

New DMVs in 2014 - A list of the new DMVs in 2014 and how they are useful.

Spackle - Kill SPIDs - A short piece that looks at finding an issue, say a runaway/stuck process, or a blocker, and then killing them.

Saving Execution Plans - Looking for a quick article that shows a user how to run a query, save the execution plan, and then...


SQL Server 7,2000 : T-SQL

Drop Non Cluster Indexes - Hello, i want to drop all the non cluster indexes on a table. i do not know the names of the...


Career : Certification

Is it good to pass 70-433 now or should go for SQL 2012 developer certification? - Hello, Is it good to pass 70-433 now or should go for SQL 2012 developer certification? Is 70-433 certification is valuable...

This email has been sent to {user_email}. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
This transmission is ©2014 Red Gate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com