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

Byte Me: Cubical Life

Bob Lang from SQLServerCentral.com

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

ADVERTISEMENT
SQL Compare

Need to compare and sync database schemas?

Let SQL Compare do the hard work. ”With the productivity I'll get out of this tool, it's like buying time.” Robert Sondles. Download a free trial.

45 Database Performance Tips for Developers

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 Search

Have you tried SQL Search yet?

SQL Search has one job, and it does it well. Search database schemas for fragments of SQL text in sprocs, functions, views and more. Download Red Gate SQL Search - it's free!

Featured Contents

 

Stairway to SQL PowerShell Level 6: PowerShell Modules

Ben Miller from SQLServerCentral.com

In this level, we will walk through creating and using modules for PowerShell. Modules are simply a collection of functions that are most likely related to each other and packaged in a way that allow you to import them as a group. More »


 

Free eBook: Fundamentals of SQL Server 2012 Replication

Press Release from Red-Gate

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege. More »


 

Options to Move a Big SQL Server Database to a New Drive with Minimal Downtime

Additional Articles from MSSQLTips.com

This article outlines the pros and cons associated with the different methods for moving SQL Server databases to new storage within a 15 minute timeframe. More »


 

From the SQLServerCentral Blogs - Collation: Temporary objects and variables: Demonstration

Kenneth Fisher from SQLServerCentral Blogs

I had a recent run in with collation problems and it got me started reading about them. As I read... More »


 

From the SQLServerCentral Blogs - Webinar – Easy SQL Server Benchmarking

kleegeek from SQLServerCentral Blogs

On Thursday, May 1st, I will be presenting a new webcast with Tegile Systems entitled “Easy SQL Server Benchmarking”. Abstract: Do you have a new piece of... More »

Question of the Day

Today's Question (by Shanjan Sapra):

How do you ALTER computed columns in SQL Server ?

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: computed columns.

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

SQL Server Execution Plans

SQL Server Execution Plans shows you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including: Which indexes are being used, and where no indexes are being used at all. How the data is being retrieved, and joined, from the tables defined in your query. How aggregations in GROUP BY queries are put together. Grab your copy today from Amazon!

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I have upgraded my instance of SQL Server to 2014 to take advantage of memory-optimized tables. If I do not want the cardinality estimatior to be used in a specific database, what can I do?

Answer: Change the compatability mode of the database to 110.

Explanation:

If you want to run an entire database with the old (SQL Server 2012) cardinality estimator, you can set the compatability mode back to 110.

Ref: Cardinality Estimation - http://msdn.microsoft.com/en-us/library/dn600374%28v=sql.120%29.aspx


» Discuss this question and answer on the forums

Featured Script

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Ola Hallengren from SQLServerCentral.com

Award-Winning SQL Server Maintenance Solution for running backups, integrity checks, and index and statistics maintenance on all editions of Microsoft SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Server 2014.

The SQL Server Maintenance Solution is free.

Ola Hallengren
http://ola.hallengren.com

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

Am using Windows Server 2008R2,In this C:/ Drive Space getting increase - Dear All, I know this is some what get irritate to you,Very sorry for that but i hope that you can...

How to configure transnational replication Between two different domains and non trusted domains - Hi, I am new to replication. Is it possible to configure transnational replication between two different domains also non trusted domains. It's...

Going from SQL 2008 R2 to 2014 - I've got SQL Server 2008 R2 Developer Edition on my desktop (I think it's a 4 year old machine). I've...

Having same server name for principal and mirror server, does it work? - I have a mirrored database from server SRV-SQL01 (principal) to SRV-SQL02(mirror). Users/Developers access SRV-SQL01 via a DNS alias called "App-SQL". Developers have...

Linked Servers to MySQL Login Timeout - Hi, I want to set up a Linked Server between my mssql 2014 and a MySQL. I set up the system dsn...


SQL Server 2014 : Development - SQL Server 2014

Anyone Using or Planning to Use Memory-Optimized Tables? - I was just wondering if this feature will be used in the real world. Not being able to have identity columns...

Null instead of 0 - Friends, I have a excel sheet with some data and blank columns. I have a ssis package using to import...


SQL Server 2012 : SQL 2012 - General

chache queries - Hi , Do you happen to know of a way to invalidate cached query plans? I would rather target a specific...

SQL in a DMZ - What is everyones view on accessing SQL data which is stored on SQL instances in the DMZ via management tools...

VM's for a demo - local or in the cloud? - I am not really sure where this question fits in as far as the forum goes - so feel free to...

DBCC Shrinkfile empty file not distributing data evenly in primary file group with multiple files - Could somebody help me tell me why shrinkfile empty file does not redistribute data evenly in the primary file group...

Instance wise CPU resource utilization report - How to get Instance wise CPU resource utilization report in sql server 2012? I have 2 sql server instance INST1...

Permissions on sequences - Hi On a DB role I created i am getting ALTER permission denied on Sequences, I am not getting anything like...

Renaming AlwaysOn 2012 Availability Groups? - Hi, We had 3 Availability Groups set up in SQL 2012 last year but they were poorly named so I am...

Backup "fails" - A few months ago, I added a simple, one-line job to backup one of my SQL Server 2012 databases -- a...

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...

Always ON setting up a C node - I have an A & B node set up and running. I now want to add a C NODE. The catch...

SQL 2012 Maintenance Plans[Full-Backups] fails - Hello, I have created a database backup maintenance plan on my new SQL 2012 Instance and they are failing with the...

Rebalancing data in file groups. Need help - I am looking for the easiest way of rebalancing data across multiple files. Instead of creating a secondary filegroup and...

AlwaysOn High Availability group showing all Databases. - Hi guys, I came across an issue while migrating from SQL 2005 to SQL 2012 and using AlwaysOn Group. For...

SQL Design Question - Hi, I am designing a database and would appreciate some thoughts. I am thinking about creating a Telephone table to handle...


SQL Server 2012 : SQL Server 2012 - T-SQL

updated Aggregate column - I am trying to create an aggregate table where the value is a rolling sum. Type a on date 1...

SQL query to fill RAM? - I work for a federal government client who restricts us to using virtual machines for dev work. Now the VM...

Create view with exploding rows into multiple - I have a table like below: ItemId Amount Tax1 Tax2 SrvType 111 100 10 20 1 112 200 10 2 113 300 10 30 3 Now I want to...


SQL Server 2008 : SQL Server 2008 - General

Any tricks for simulating a "Connection Timeout Expired" message? - wondering if anyone, during their travels, has ever found a way to simulate a "Connection Timeout Expired" message. It's to...

SSIS error with using the Conditional Split - Hi All, I am using the Conditional Split and in the condition box I am trying to compare two columns to...

Table locks - Hello all i have a question regarding SQL locks. If you have a stored proc which does something similar to...

time-out in a Job using link server - i have this error in a job, this job is using linked server Message Executed as user: Domain\user. OLE DB provider "SQLNCLI10"...

SSIS - How to pass data set from one Data Flow to another? (or other options?) - I am developing a package that needs to be able to export any of 5 different queries (all with different...

SQL Job History Information - Hi, I want to query the Job within the Job Activity Monitor, I would like to get the following information: Job Name, Setp...

Select ID with the Greatest Rank - I have a table that contains data in the following format: Here is an example of the table: ID Source Rank 152 Foo...

Server Side Trace - I am wondering if someone a help a brother out? I will try to give as much information as possible. Problem:...

Covert all characters in field into their ASCII code - Hi i have a column with the following data in ..... The data varies from numeric to capitals to lower case...

Reporting Services - large Report Model SMDL files - Hello! I am generating and modifying the report model programmatically and it comes out as big as 260MB - for over...

Manually Grow database files - We have a policy to try and keep 20% free space in all database files - especially data and index files....

Am using Windows Server 2008R2,In this C:/ Drive Space getting increase - Dear All, I know this is some what get irritate to you,Very sorry for that but i hope that you can...

SQL JOB HISTORY Didn't show Step name. Shows only (job outcome) - Dear Experts, I need your help. please help me. I have maintain 9 SQL server 2008 as DBA. one of my server's...

Backup Differential - When doing a differential backup, is it better to save to a new file or use the full backup file? In...

Query to find the size of each row in a table - Hi, Is there any query available to find the size of each row of a table?

Setting dynamic filters for dropdowns - Hi, I have a gridview and a dropdown filters in the page. Also I have a date column in gridview which...

Reset sp_prepexec - Can we reset sp_prepexec and sp_execute When i am running the sp_prepexec the id is generated say it is 22 then...

166 days to create index - I have a table containing 2,163,568,622 rows hosted on SQL server Standard 2008. Attempted to create a new index: -------------------------------------------------------------------------------------------------------------------------------------------------- Using TEMPDB = ON...

Not able to open ssis pacakge - Hi All , Am trying to open ssis packge but it is giving error saying "There were errors while the pacakge...

Copy Database and Identity - We have a database running on a SQL 2008 R2 server. The database has a table with a single column for...

Select statement - Effective running - Hi All, I have an select statement which needs to be run 15 times with a slightly different where clause and...

Access with ADOX too slow - Hi My questrion is about connection to DB. I had migrate my DB Access to DB SQL Server 2008 and I'...

Transport-level error referring to "network name is no longer available" - but not referring to name... - Hi All, I'm continually getting the following error condition from a C#.NET 4.0 console application we run: A transport-level error has occurred...

how to see discarded job history - Hi All, Is there any way to see discarded job history ? Because I am not able to see the history of...

Restriction on DML Statements in SSMS - Hi, I would like to know if there is any option to Restrict DML statements in SSMS for a user where...

unable to connect to the instance - This is the error I am getting: A connection was successfully established with the server, but then an error occurred during...

Restore compressed backup creates 5x larger database - Greetings all; I've been trying to find some information about what might be going wrong here. I'll be the first...

BCP Command, Error - Login failed for user - I am using this BCP command to output the data from a table into the file, and getting this error...


SQL Server 2008 : T-SQL (SS2K8)

Outer Join performance - Can someone please give me advise on a better way to write the following? SELECT a.BoxId, b.field1 as value1, c.field1 as...

SQL DB Mail - Hi, I'm sending report based on below DB Mail query from mentioned data format table. But i'm getting invalid format...

Create batch file to selectively run SQL files - I have about 1200 sql files in one of my folders. Almost all of these files do data inserts and...

SQL Help requested to Get Daily and Weekly OT - Hello Everyone, I need to pull a report from a table which gives me daily totals, I'm asked to get regular...


SQL Server 2008 : SQL Server Newbies

Help a complete noob with a project - Hello everyone, i have a project for a datawarehousing class and could really use some help in this. Heres what i...

SQL Credentials - Is there a way to give a user rights to change the password on a credential without giving the Alter...

Error in Drop Create stored procedure. - New at SQL Server 2008 R2 ... The script below generates a stored procedure. Just recently I start getting an error...

Display Binary Image in Report Builder from Database - Anyone have any suggestions on how to display a Binary Image in Report Builder 3.0? I'm trying to display the...


SQL Server 2008 : Security (SS2K8)

Windows Account with sysadmin when it shouldn't - Hello guys, I am sorry if the question is fairly simple but I haven't been able to find any solution. We...


SQL Server 2008 : SQL Server 2008 High Availability

Replicate databases for querying only - Hi, Would appreciate any help in implementing a solution for the following: Source server: sql server 2008 r2 enterprise Target server: sql...

one db versus multipl dbs - Hi everyone We're looking into setting up a SQL cluster for our app. Our current setup is based on a very high...


SQL Server 2008 : SQL Server 2008 Administration

Latching and Locking... - Hi Can you please tell about Latching and Locking and are these same with each of them. Thanks in Advance!!!

SQL Server Packets Error Rate - We seem to be getting these alerts on our DB server from the Spotlight Monitoring tool every morning. Network - SQL...

Workaround for filestream with group - Hi, I have faced a difficult situation here, This is my scenario, In our company, we need to implement the [b]filestream...

SQL SERVER AGENT I SNOT RUNNING.... - hI experts.... Today morning i was deleted eventveiwer logs(applicatin,system) at that onwards my server is running without sqlserver Agent. my sysadmin...

Procedure for adding new named instance to production sql server 2008 r2 std. ed. - Hi I have a sql server 2008 r2 std. ed. box with only default instance on it. It is patched to...

Is any one can give the Exact reasons for growing the Log Size - Dear All, Is there any Exact reasons for growing the Log Size , I Have referred some online guides but, I didn't...

Msg 8501, Level 16, State 3, Line 1 MSDTC on server 'My-Server' is unavailable. - I tried following code in SQL2K8r2..... for getting login modes of Linked server's code is absolutely correct. But when I...


SQL Server 2008 : SQL Server 2008 Performance Tuning

Insert triggers updating an audit table - Hi, Apologies if this is in the incorrect forum. I have created a trigger using the below code: CREATE TRIGGER [TriggerName] ON [InsertDataIntoThisTable] AFTER INSERT AS UPDATE [AuditTable] SET...


Cloud Computing : General Cloud Computing Questions

Cloud based learning environments - Hi all, I wondered if anyone could help suggest a cloud hosting provider. I am mentoring a young SQL Server newbie and...

Migrating to Amazon - IOPS Question - Hi All, I am working on migrating databases on multiple servers to Amazon. I have a question regarding IOPS. I can...


SQL Server 2005 : Administering

Remove a level from the Parent-child Hierarchy dimension doesn't work. - HI, I am trying to remove a member from the Parent-child Hierarchy dimension. My Hierarchy has 5 Levels and i...

Evaluating CxPacket issues - Hi All, First the configuration details. SQL 2008R2 Standard, SP2, 64Bit on Windows 2008R2 EE 64 Bit. HP DL 380 with 2x4 processor...

Cluster Disk Resources Migration - System Specs 2 Node Cluster Active/Active each with an instance Windows Server 2003 SQL Server 2005 Project: we are changing our SAN from an...


SQL Server 2005 : Backups

System Database restores vs rebuild - Hello all, I need to better understand under what circumstances you would rebuild versus restore the system databases? In a meeting...


SQL Server 2005 : Data Corruption

how to restore .ndf file in database SQL 2005 - hi all, i have mistakenly deleted .ndf file of the database and but i have a backup of that file any...


SQL Server 2005 : Working with Oracle

SSMA to migrate data from oracle to sqlserver - We migrated data from oracle to sqlserver using SSMA but when we see data of sqlserver on .NET GUI, formatting...


SQL Server 2005 : SQL Server 2005 General Discussion

BackupDirectory is not available - Hi, has anyone meet with this problem ? Yeasterday I have installed a new SQL Server 2005 side by side with...


SQL Server 2005 : SQL Server 2005 Performance Tuning

How can I check the Long Running Query by using Stats.. - Hi All, Here am Using SQL 2008, How can i check the Long Running Query by using the following Query and how...


SQL Server 2005 : SQL Server 2005 Integration Services

Login timeout when trying to add an existing package on SQL Server to a solution in VS - I have an integration server where I can connect to in SSMS without any problem. But when I try to...

SSIS 2005 service not starting after KB2716429 - Hi all, We have been experiencing problems with SSIS service not starting with the usual useful error "The service did not...


Reporting Services : Reporting Services

SSRS 2012: can create reports but not publish? - First off, my SSRS install is for learning, so if plowing it under and reinstalling from scratch is a good...

Table two Column - Hello I have a table that gives me information, it is for example in column 3 appears OK the values...


Reporting Services : Reporting Services 2005 Development

Page numbers in SSRS while exporting to pdf file - Hi I am designing the report in SSRS. In footer I have set the page out of (no. of pages)....


Reporting Services : Reporting Services 2008 Development

Indicator for to remain in one cell for a group - In SSRS, I have a drill down report with three columns. One column says 'yes' or 'no.' The other column...


Programming : General

.NET SSIS Script Task issue - I am still a rookie when it comes to Visual Basic. I've been giving VB code to read a file...


Programming : Powershell

Add Network Places using PoSh - I'm getting a new Windows 7 desktop. From a powershell perspective, probably a good thing. But, I have a goodly number...


Data Warehousing : Integration Services

how to add Aggregated Transform as a new column - Hi, I have a flat file with 2 colums: TradeID and Nominal. Now I would like to add third column showing...

Mapped Network Share - Hello - I am trying to find out what is the best way to have my ssis package export data to...


Data Warehousing : Analysis Services

Dimension.Currentmember ? - Hi I am using ASSP.DiscoverSingleValue() to get the description set on the measure according to asstoredprocedures.codeplex.com/wikipage?title=DiscoverSingleValue In combination with Gregs solution: http://www.artisconsulting.com/blogs/greggalloway/Lists/Posts/Post.aspx?ID=17. That works...


SQLServerCentral.com : Anything that is NOT about SQL!

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...


SQLServerCentral.com : Articles Requested

Creating Memory-Optimized Tables - A piece that shows how to create memory-optimized tables in 2014 and includes some of the restrictions and limitations. Perhaps...

Dimensional Modeling - BI - An article(s) to walk people through how to think about dimensional modeling

Create a Measure - BI - A basic article for users that shows how to create a measure. Not choose, but create with screenshots and code.


SQL Server 7,2000 : T-SQL

Alternative to manual pivots - Hey all, I have a rather complicated report using a stored procedure that uses the; SELECT @vals = @vals + ' ' + REPLACE( REPLACE( then lots of...


Career : Certification

Upgrade Exams - AKA Certification Tribulations I've previous 2008 certification but, before Christmas, I failed upgrade exam 70-457 (by ONE question. gah.) Next time...


Career : Resumes and Job Hunters

Looking for a SQL Server DBA 2005 or 2008 internship or volunteer opportunity - I am a certificated SQL Server DBA in both 05 and 08 since 2010, but has had no joy successfully...

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