| A community of more than 1,600,000 database professionals and growing |
| | | Are Indexes Actually Changes to the System? I haven't thought about this in some time, but Brent Ozar raises an interesting question: should index changes require change control? I've worked in an organization that didn't consider an index change to be an item that was presented as an official change. They were seen somewhat like adding new users or changing a firewall rule. These were ticket requests that could be triaged and made by an individual group without notifying the rest of IT. I've also worked in organisations where an index change was viewed as a deployment and subject to change control procedures. Not that the network or security people cared about the details of the index, though the help desk might. These just wanted to be aware as any deployment change could affect their departments. In today's world where many companies seek to adapt faster to changing customer demands or market opportunities, I think the idea of meeting every week to discuss any upgrades or changes to applications is somewhat silly. Certainly large changes, like major application upgrades to ERP systems, new security hardware, and alteration of core infrastructure ought to be debated in a larger group. Deploying changes to an application isn't one I'd think deserves the debate. At least not if your organization is trying to become more efficient. I do think a way to avoid issues is to work more closely with the development group if you are in operations or vice versa. I'd be sure to let other app teams know about index changes? Certainly Brent lists a number of potential problems, many of which could occur. A new feature might break and prevent inserts, exports could use more disk space, imports might eat up data and backup space, queries could cause slowdowns or blocking. These are all possible, maybe even probable. I agree with Brent in that any changes need to be tested. I don't know about any sort of formal change control, but there ought to be a process that evaluates the changes and mimics them in an environment that allows you to determine the production impact. Using a known, automated process with testing and well documented deployment actions will reduce the risk, but perhaps not eliminate it. However, when you find issues, if you have an automated process, it's easy to add tests or alter the process to ensure that it will succeed in the future. Especially if you examine the effects of these changes and learn to avoid problematic development or deployment patterns in the future. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| | The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.2MB) podcast or subscribe to the feed at iTunes and Libsyn. The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT | | | | Write, format, analyze, and refactor SQL fast with SQL Prompt Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with code analysis you get suggestions to improve your SQL as you type. Download your free trial |
| | | | How to lead DBAs to embrace DevOps, rather than fear change In this 30 minute session, Microsoft MVP Kendra Little will share three key insights from the recent webinar, "Biggest Issues in a DBA's World Right Now." This executive summary will help you understand what motivates database professionals and how you can inspire your database staff to become agents for positive change.
Register now |
|
|
|
| | | | | Steve Jones from SQLServerCentral.com Learn how you can determine which connection is using the Dedicated Administrator Connection. More » |
| | Redgate invites you to take their Estate Management Research Survey. Their aim for this questionnaire is to gather some information around the importance of certain tasks within the wider umbrella of ‘Estate Management’ and your satisfaction with your current solutions to them. The survey should take around 10 minutes to complete. Help them continue to support and build relevant tools to help you in your job and in recognition of you taking time to help us, they will award an Amazon voucher or equivalent to the value of $50 to one lucky survey participant. This will be determined in early October 2018. More » |
| | Additional Articles from Database Journal Join Anoop Kumar as he discusses two modern design patterns to handle Advanced Analytics on big data, and Real time analytics. More » |
| | Grant Fritchey from SQLServerCentral Blogs If you’re watching Microsoft Ignite or tracking the information coming out of it on social media, then you know that... More » |
| | Tim Mitchell from SQLServerCentral Blogs It has been almost impossible to avoid reading about the numerous large-scale data breaches reported on a seemingly daily basis.... More » |
|
|
| | | Today's Question (by Steve Jones): I have this table with a column set. CREATE TABLE UserConfig ( UserConfigKey INT IDENTITY(1,1) NOT NULL CONSTRAINT UserConfigPK PRIMARY KEY , UserID INT , IsActive BIT SPARSE , IsSubscriber BIT SPARSE , DefaultQuantity INT SPARSE , Options XML COLUMN_SET FOR ALL_SPARSE_COLUMNS ) GO I want to insert a new row and use this statement: INSERT dbo.UserConfig ( UserID , IsActive , IsSubscriber , DefaultQuantity ) VALUES (8, 1, 1, 5, CAST('<IsActive>1</IsActive><IsSubscriber>1</IsSubscriber><DefaultQuantity>7</DefaultQuantity>' AS XML ) GO What happens? |
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: Column Sets. 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 | | Pro Power BI Desktop This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): What happens when I run this code? DECLARE @d DATETIMEOFFSET , @c VARCHAR(30) ; SELECT @d = '20180903 11:55:34 -7:0' ; SELECT @c = @d ; SELECT @c AS 'TheDate' ;
Answer: '2018-09-03 11:55:34.0000000 -07:00' is returned Explanation: The conversion takes place correctly and '2018-09-03 04:55:34.0000000 -07:00' is returned. Ref: Implicit Conversions - click here » Discuss this question and answer on the forums |
|
|
| | | | Matt Frend from SQLServerCentral.com Occasionally the SQL Data Collections will stop collecting even though the collection sets are still running (see "System Hangs" section in this post: click here). If none of the conditions under that section apply, and restarting data collections does not work, then the cache files may also need to be deleted, in addition to a restart. To simplify this process, you can create a SQL Agent job to do all of this automatically. The SQL Agent job should have 3 steps: 1. Stop the Data Collections (example is for the 3 default collection sets) 2. run the stored procedure "uspDeleteCacheFiles" - this detects the cache file location and then deletes all files with a ".cache" extension. It also confirms whether the data collection sets have been stopped, as this must be the case before cache files can be deleted. This procedure also requires XPCmdShell for file system access to be enabled: /* enable XPCmdShell for file system access sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'xp_cmdshell', 1;
GO
RECONFIGURE;
GO */ 3. Start the data collections This process has been tested on all SQL Server versions after SQL 2008. We have found that restarts have periodically been required on all SQL Server versions, as explained under the "System Hangs" section in the Troubleshooting post above. 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. Script to View Server Role Permissions - I have a script which creates a server role called dbareadonly. Here is part of it: USE master; GO CREATE SERVER ROLE... Failover - AG issue - Hi All, Issue: We have 2 instances say A01 AND A02. The client has network issue sometimes and they loose connection... How to build an app with GUI that works with SQL Server? - I have to create a project which should have a GUI because people who gonna use it don't know TSQL.... sql server does not seem to have an equivalent of Oracle %ROWTYPE ? - It seems that SQL*Server does not have equivalent of Oracle %ROWTYPE ? Unless I am looking at old answers on the web ... Windows user has SELECT and DB_DATAREADER writes still gets: "The SELECT permission was denied on the object" - This is a head scratcher. I have a windows user, I even deleted and recreated the users account on the server... insert the records in Table 2 whenever the records delete in Table 1. - Hi, I would like to insert the records in Table 2 whenever the records delete in Table 1. How to achieve this. Please suggest. Thank you... Always on with an SQL Cluster and 2 nodes - Hello all, I have searched everywhere and can't seem to find an example of setting up Always on where the primary... Delete data with sliding date window - Hello, I have a table where I have one year+ of data, and I need to delete the current month,... UNIONs + PK-violations - Hello, Some background first: I have some XML Export tracking order changes. For this we use change tracking on order / row tables... Patching Always on Secondary - Read only node - Hello, There are three nodes in Availability Group, Node 1 as Primary, Node 2 Read-Only, Node 3 Secondary. When Patching Node 2... Replacement of role db_owner - Hello I am working on a folder removing the db_owner role for some users and replacing it with a specific rolefor... Difference between AG && FCI - Hi, what is the difference between AlwaysOn availability groups and AlwaysOn Failover cluster instances thanks Varchar(4000) and Performance - Hi, What are the disadvantages of using many columns with varchar (4000) or nvarchar (4000) in terms of performance, DB size,... Using Central Management server to schedule and email report on failed jobs. - Hi I would like to know how to use CMS to schedule a sql statement which checks for failed sql... Need help in writing Query - Need help in writing query. I table Requestdetails which contain the below data. PkeyRequestIdStateNameResolverGroupDateCreated1123Resolved299/27/18 15:162123Acknowledge299/27/18 15:163 how can we auto increment by 1 from the max ID with an update or an insert into to the same table. - I want to insert into the same table with an update or an insert into but by incrementing the SomeThingElseID by... Backup whole instance SQL Server 2008 - Hi. Is there a was to take backup of whole instance (databases, logins, jobs, etc.)? I have an instance where... Can i sort a cross tab horizontally? - i have a report that shows top 20 sales each month for the past 12 months by product. I have a... Return temporary table from Stored procedure - I have a generic Sproc that I want to reuse. It returns a resulset which the Parent SProc needs to... 70-461 Practice exams - Hey everyone. I'm planning on taking my 70-461 exam at the end of the month and wanted to take a... |
|
| This email has been sent to newsletter@newslettercollector.com. 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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
