| A community of more than 1,600,000 database professionals and growing |
| | | What's a Toaster? This editorial was originally published on Feb 5, 2010. It is being re-run as Steve is away on vacation The other day I purchased Winzip 14 since I needed to unlock a .RAR file. I posted a note on twitter since I was surprised that it was at v14. The last time installed this a few years ago, it was v11. How much change is needed in a zip utility? I suppose there are new formats available, but do they really need a new version? I got a number of responses that recommended WinRAR, 7-Zip and more. However I grew up using WinZip years ago, it's worked well, and I don't mind spending a little $$ on a good utility. It's polished, and been rock solid for me. And it reminded me of something Andy Warren says: "It's a toaster." Meaning that it's a generic item, and that for the most part, they all work the same. I know there are some fancy toasters out there, but for the most part they all do one thing, and it's not usually worth more than 10 seconds spent picking one out. So for an interesting Friday poll, I wanted to ask you what you think is a generic item in the technical world. Today's poll is: What's a toaster for you? By that I mean what software or hardware do you use or need that isn't worth really spending time researching. Is it the OS? Do you just install the current version of Windows and not worry about it? Is it SQL Server itself? Is it some utility like a defragmenter or a compression utility where you feel they all essentially work the same. Do you think all laptops do the job for you? Let us know this Friday what you think might have become a basic tool in your career. No answers are wrong, and I'd love to know if you find any old laptop acceptable for your job. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | 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 track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more |
|
|
|
| | | | | Eric Madariaga from SQLServerCentral.com Use the TDS Remoting feature of the ODBC Driver to set up a linked server for Salesforce data. More » |
| | Phil Factor discusses SQL Prompt code analysis and the necessity for bracketed, or parenthesized, expressions. More » |
| | Bert Wagner from SQLServerCentral Blogs This month’s T-SQL Tuesday topic asked “What code would you hate to live without?” Turns out you like using script... More » |
| | Andy Warren from SQLServerCentral Blogs Earlier this year Brent Ozar invited me to attend some of his online classes for free. Free is good! Training... More » |
|
|
| | | Today's Question (by Steve Jones): In SQL Server 2016, I want to create a trigger that prevents the altering of any table in only one database, not on the whole instance. How should I write this? |
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: DDL Triggers. 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 | Extract, Transform, and Load with SQL Server Integration Services: With Microsoft SQL Server, Oracle, and IBM DB2 Readers will learn by example how to use Microsoft SQL Server 2016 Integration Services (SSIS) as they design and implement extract, transform, and load (ETL) solutions to support a business application that integrates with a data warehouse and an online Web store across a heterogeneous system. This volume describes proven methods to support common ETL needs, such as databases communicating directly with each other, using files to exchange data, or performing database operations using Web services. Pick up your copy of this great book today at Amazon today. |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have this code to create a table and add an index. CREATE TABLE dbo.PurchaseOrder ( PurchaseOrderKey INT IDENTITY(1, 1) NOT NULL CONSTRAINT PurchaseOrderPK PRIMARY KEY , PONumber VARCHAR(100) , CustomerName VARCHAR(100) ); CREATE INDEX PurchaseOrderNDX_CustomerName ON dbo.PurchaseOrder (CustomerName); GO I now run this: ALTER TABLE dbo.PurchaseOrder DROP COLUMN CustomerName GO What happens?
Answer: The code errors out as a column in an index cannot be dropped. Explanation: If a column is included in an index, it cannot be dropped. The index must be dropped first. Ref: ALTER TABLE (Drop section) - click here » Discuss this question and answer on the forums |
|
|
| Database Pros Who Need Your Help |
| | Here's a few of the new posts today on the forums. To see more, visit the forums. Availability Groups either -- Windows 2016 Failover Cluster vs SQL Server Cluster - Hello, I supported SQL Server Clustering for a number of years, but now I am facing a task to implement Availability... Automate daily table backup - Hi, i have task is assigned to take the table backup daily wise. below is the format tablename_yymmdd please suggest Assistance with DATETIME calculation when comparing to VARCHAR column (Test code included) - Hello, so I'm trying to get the difference in MINUTES between two columns. One column is a DATETIME column while the... float error in t-sql scalar function - Hello Everyone, The below code is giving me error: Msg 3623, Level 16, State 1, Line 27 An invalid floating point operation occurred. [code... Odd memory stats - I'm troubleshooting a 2016 SQL instance that is reportedly getting slower. An odd stat I don't understand is Target and... dm_db_index_physical_stats - LIMITED or DETAILED - I'm interested to hear what most DBAs do to evaluate fragmentation using dm_db_index_physical_stats. Using this web site as a reference: dm_db_index_physical_stats I have t A SQL 2017 Licensing Question - Hi, We have three VM (V1, V2, V3) running on 3 separate host (H1, H2, H3). H1 has16 cores, H2 has... Last 12 months report - Hi, I have been trying to get a report to display the top 10 categories by sales for the current... How to implement the threading in storeprocedures without duplicate - Hi All, My table have 10000 records and i create the 5 store procedures and my 5 applications exec the... error during upgrade sql server 2008 to 2014 - Hello everyone I proceed to upgrade my production instance from sql server 2008 to 2014 the upgrade procedure had an error here with... Extended events question - Hi All, I have a question related to extended event ring buffer target. In SQL Server, how many ring buffer(s) will... grouping by * - I have this code: select D.* ,H. as RH_Recon_entry ,max(cast( as Date)) as Recon_File_Date from . D LEft Join . L on D.ENTRY_NUM = l.Customs_Entry_Num inner join . H on H.trans_sk How to find if a column of a resultset has a content? - There is a report I print, which includes a list of people, e.g. students, with their relevant content, e.g. their... Data Vault Modelling - Hi Dear Friends, I have got a project where I need to implement "Data Vault Modelling". I was completly blind about this... Cursor Or Not - Name Date Cost1 Cost2 Cost3 Cost4 AAA 2011- Islands And Gaps - I'm Stuck...Again - I feel like I've solved this type of problem before, and yet I'm stuck and need some expert help. Here... Need help in real time query tuning scenario in Adventure works - Hi all, I have been working in TSQL for 7 years but till now i have never faced to tune... Trace shuts sql service down - Greeting All, I've come across a server that, when I start a trace, within moments the SQL service shuts itself... remove Identity from a column - Hi Dudes, I have a Table Which has a column that is set to identity by mistake and it is on... Joining large tables to small tables. - Hi I hope this is an easy question to answer. :-) I'm joining a large table to a small table and results... |
|
| 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 |
|
|
