I ran across a note recently on Twitter from Adam Machanic. He wrote: Just spent most of the day working through a subtle PK issue - 1 bad row out of 18M. Would have killed for this. The item in question was a Connect item, one with almost 500 votes. It's a good one, and I'd encourage you to vote for it. I know that it seems many of these items are never worked on, but some changes make it into the product, so I'd ask you to continue to vote for change.
When Connect was first introduced, Andy Warren and I debated the value of the platform. On one hand it made good sense to directly feed information back to developers, but on the other hand, it was likely that those items that got more notoriety or votes might get fixed, even if they weren't necessarily good ideas. The popularity of an item doesn't necessarily mean it's one that should be fixed in the product first. We also worried about one of the big problems of the platform and that is that a tremendous amount of noise of entered and it becomes hard to triage the submissions.
As I watch Connect evolve, I can't help but think that it's been mostly a failure from my perspective, with a few notable successes, like Service Pack 3 for SQL Server 2005. There's too much noise and too many items ignored. However I also do think that those items that get lots of vots do get more consideration from Microsoft. More votes doesn't mean that the feature will get fixed, but I do believe the item gets talked about. (As an aside, please vote for more, final Service Packs)
Personally, I think that raising awareness of possible suggestions or problems is a good idea. I'd love to see a top 10 list of Connect items from MS for consideration every month. Having them highliht some items they're considering from the list might help focus attention from customers. I don't think that's likely, but I wonder if highly debated suggestions might be worth highlighting at SQLServerCentral. Would you like to see a Connect item of the week? Something you could vote on or even debate as a good idea? I would, and I'd consider adding them as a way to help improve the platform that I enjoy working on the most.
The first thing you need to understand about SQL Server is indexes, but somehow many of the basic questions don't often get asked or answered much on forums. Rob Sheldon answers some of these questions about SQL Server Indexes and indexing. More »
SQL Saturday is coming to Huntington Beach, CA on April 26 2014. This is a free day of training and networking for SQL Server Professionals - there are also 2 paid-for precons on April 25 presented by Jason Horner and Bradley Bell. Register for SQL Saturday Orange County while space is available. More »
Today I noticed couple of changes(Neat changes !) for Data Collector in SQLServer 2014. This post is a detailed walk-through of setting... More »
Question of the Day
Today's Question (by Steve Jones):
You are using a symmetric key to encrypt some data in a stored procedure. However you want to follow good coding practices and stop using the key when you are done with the encryption before you execute other code. What T-SQL would you use to ensure that the symmetric key, SalesSymKey, cannot be used later in your session?
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: Encryption.
We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the
SQL Server 2012 brought in some great new features and one of the important ones is scalability and performance via AlwaysOn. AlwaysOn is a superset feature and is a combination of many things you will learn about. As the language suggests, this technology achieves a SQL Server infrastructure that can be "always on". For businesses that run 24x7 downtime means the loss of business. This type of risk is out of the question for these businesses. This book discusses in detail the concepts of SQL Server AlwaysOn starting from the basics.
Yesterday's Question of the Day
(by Shanjan Sapra):
What is the surest way to check that your syntax is valid and will work with SQL Server?
Answer: Set the context of your execute with the help of NOEXEC setting
You can set the context of your execute to On or Off with the help of NOEXE setting. Example using setting NOEXEC.
Check the following query:
GO -- Change Setting of NoEXEC to ON SET NOEXEC ON; -- INSERT Statement INSERT INTO IT.Shift (Name,StartTime, EndTime,ModifiedDate) VALUES ('Shanjan', GETDATE(), GETDATE()+1, GETDATE()); -- Change Setting of NoEXEC to OFF SET NOEXEC OFF; GO -- Check Table Data SELECT * FROM IT.Shift;
---Objetivo: RECONSTRUYE INDICES DE UNA BASE DE DATOS
---Autor: Andrés Noé Michaca Trujillo
select 'ALTER INDEX [' + ltrim(rtrim(ind.name))+'] on [' + ltrim(rtrim(esq.name))+'].['+ltrim(rtrim(OBJECT_NAME(ind.object_id))) +'] REBUILD PARTITION = ALL WITH ('+
when 1 then ' PAD_INDEX = ON, '
else ' PAD_INDEX = OFF, '
' STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, '+
when ind.is_unique =0 and ignore_dup_key= 1 then ' IGNORE_DUP_KEY = ON, '
when ind.is_unique =0 and ignore_dup_key= 0 then ' IGNORE_DUP_KEY = OFF, '
+'ONLINE = OFF,'+
when 1 then ' ALLOW_ROW_LOCKS = ON, '
else ' ALLOW_ROW_LOCKS = OFF, '
) ) +
when 1 then ' ALLOW_PAGE_LOCKS = ON)'
else ' ALLOW_PAGE_LOCKS = OFF)'
from sys.indexes ind
inner join sys.sysobjects obj on
inner join sys.schemas esq on
where obj.type='U' and ind.name is not null and upper(OBJECT_NAME(ind.object_id))<> 'SYSDIAGRAMS'
order by OBJECT_NAME(ind.object_id)
Need Query for summarizing data
- Hi there,
I need query for the attached output
create table #Wholeseller ( wsid varchar(100),[Productid From] int, [Productid To] int, units int)
create table #Retailer ( retid...
how to update value from c2 to c1
We want to update last value of c2 to c1 , which value is linking c2 and c1
- 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!
When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene...
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.