| A community of more than 1,600,000 database professionals and growing |
| | | One Million Is a million writes/sec a large number? I guess it's all relative, but I'd consider it a fairly large number. Our peak transfers for SQLServerCentral are in the hundreds/sec, though we're not really a busy database server. Some of you might have much higher numbers, and if you're in the 100,000/sec and can let us know, I'm sure others would be interested in hearing about your experiences. I ran across a piece on the Uber database infrastructure that I found impressive. No, Uber doesn't use SQL Server (they use Cassandra), but they have worked to build a large scale infrastructure. Their goals: 1 in 100,000 requests can fail 1,000,000 writes/sec > 100,000 reads/sec Those are quite impressive. While I'm not sure they've ever achieved these levels in production, I'm glad they're testing at these points. I think far too many people forget to test the limits of where there systems might grow and only stick with where they are today. Or where they were a month ago when they refreshed a test environment from production. Test at larger than production levels, at least once in awhile. There's something impressive with one million. Getting to a MB, roughly 1mm bytes, was impressive to me. Not such a big deal now (with pictures requiring > 1MB), but 1mm MB is a terabyte, and while I carry that in my pocket, it's still an impressive size. Crossing one million members at SQLServerCentral was impressive. I think $1mm is a lot of money. One in a million still seems like a very small chance of an event. At the recent Data Science Summit, we see SQL Server scoring over 1mm fraud predictions/sec. Achieving 1mm of anything in a database system is still a large number. I know many people have tables with over a billion rows, but I'd still say a million is large. Perhaps you disagree, but I'm still a little awed at seeing SQL Server process a query of 1mm rows in less than a second. 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.1MB) 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 | | | | SQL Clone – create database copies fast! Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. Join the beta. |
| | | | New Redgate SQL Compare 12 has landed! SQL Compare 12 has landed with a brand new user interface, support for SQL Server 2016, and a wealth of fixes and improvements. Check out this blog post from Redgate's Carly Meichen to hear more about what’s new, why the team have built it, and how. Read now. |
| | | | PASS Summit 2016 Join 4000+ data professionals at the annual PASS Summit next week, Oct 25-28 in Seattle, WA. Choose from 200+ sessions for in-depth SQL server and business intelligence training. Over 500 Microsoft experts are set to network and share their knowledge at the SQL clinic, Chalk Talks and more. Hurry, register now. |
|
|
|
| | | | | Press Release from Redgate Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment. More » |
| | This year Redgate have a breakout session featuring SQL Clone, as well as a booth in the exhibit hall. They'll be giving away all sorts of prizes including SQL-themed playing cards, flying sheep, and a year's worth of the world's strongest coffee! To find out the details of what they'll be up to between October 25 - 28, and to find out how you can attend the exclusive #RedgateRocks party, read this blog post. More » |
| | Additional Articles from SimpleTalk A major difficulty for a System Administrator who wishes to provide access for auditors, Helpdesk staff, developers and other IT people is that adminstrator roles give users more access than they need. It is too easy to make mistakes, or to make more changes than those that were signed-off. With JEA, it is possible to create role-based access control (RBAC) endpoints that define precisely what actions you’ll let your users carry out without needing a elevated, privileged administrator credentials, and which log and report all operations. More » |
| | Grant Fritchey from SQLServerCentral Blogs This is post #10 supporting Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here. When you send a query to your... More » |
|
|
| | | Today's Question (by Steve Jones): I decide I want to grant someone else the ability to back up databases. I create a new login, BackupOp, and assign a password to this account. I have two databases on my instance, Sandbox, and Sandbox2, that developers use. In the Sandbox2 database, I perform the following: CREATE USER BackupOp FOR LOGIN BackupOp; GO ALTER ROLE db_backupoperator ADD MEMBER BackupOp; GO In the Sandbox database, I do this: CREATE USER BackupOp FOR LOGIN BackupOp; GO One of our developers connects to the SQL Server instance with the BackupOp login, using the Sandbox database to run some queries. They decide to they want to also test in Sandbox2, but first need to run a backup. Does this work: USE sandbox; GO BACKUP DATABASE SandBox2 TO DISK = 'SandBox2.bak'; GO |
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: Backup and restore. 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 Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS. Pick up your copy of this great book from MVP Glenn Berry at Amazon today. |
|
|
|
|
|
| Yesterday's Question of the Day |
| | |
| | | | Darko Martinovic from SQLServerCentral.com Calculates total length of services for a employee. Calculates( addition or subtraction) two internships in form of yy.mm.dd.
The script works by SQL Server 2005+ versions SELECT
[dbo].CalcTwoInternShips('3.11.10', '17.4.12', 0, 1) --21.3.22
SELECT
[dbo].CalcTwoInternShips('21.3.22', '17.4.12', 0, 0) --3.11.10 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 standard edition 2016 - alwayson - Please let me know how many database can be configured in the always on for SQL standard edition 2016.. Also... Newbie here... Wishing to learn SQL and SSIS/SSRS/SSAS - Hi all, A newbie here wishing to ask for advice on Microsoft Business Intelligence. Hoping this is the right forum to... Differential backup too big - Since two weeks, my differential backups are getting too big. I have a 4 TB database. Our backup schedule: full... FCI + AG Alwayson 2014 - Hi Guys, I need some one to clarify please. It very urgent. We have Two stand alone SQL Server 2014 server... finding the current ID value compared to the IDENTITY value - Hi I need to find the current identity value compared to the current column value of tables with identity fields - in... Displaying Multiple rows clock event Under a different Column view - I would like to query the data were table output is by each row but i need need display the... Very bad performance on a good HP DL380 Gen9 Server - This issue is something that I haven't had much luck trying to solve via on-line research, and was hoping to... SQL error: A severe error occurred on the current command. The results, if any, should be discarded - I am using VS Studio 2105 to create a console app and SSMS 2014 v 12.0.410. I am running a... Converting SSIS 2012 Packages to 2014 - I am attempting to migrate 2012 packages that are stored in the SSISDB catalog to a 2014 instance. After migrating... Display Live clock event - Hi Experts, I need to solve below two issues in my SQL query, 1. query should not show any duplicate clock event(ex: if... Query Performance - MIN vs Top 1 - Hi guys Similar to a previous thread I started last week about query performance I need to figure out why 2... Dynamic rows into columns - Hello, I'm a SQL Server novice. I've been polishing up on my T-SQL skills while working for the last few months... DBCC Checkdb cannot exclusively lock database - We are running weekly DBCC CheckDB job. The error is "The database could not be exclusively locked to perform the... With recompile in the master stored proc - Dear all, If I have a procedure like: sp_1 (@par1, @par2) AS begin exec sp2 exec sp3 end if I add the expression "with recompile" on the master... sql query to display a trailer record at the end in txt file (using batch file) - hello, I want to display a trailer record at the end of records : the spec is as follows Trailer Record: Field Name Length Begin ... SSIS Warning - Global Shared Memory - Hi I'm busy rewriting DTS packages as SSIS packages. As and when I finish a package I run it in debug... grant execute overrides user permissions - Hi. It looks like granting a user permission to execute a proc overrides that user's insert/update/delete permissions they'd otherwise have... Restore database - Dear all, how do I know if the backup files are ready to restore without any corrupt ? How to make sure... Multi-valued parameter using pipe delimiter - I'm trying to create a report with multi-valued parameter, using a pipe delimited string. The stored procedure runs as expected.... Fact table with hundred of columns - Any alternative? - Hi everyone, I am designing a accumulating snapshot fact table to evaluate the performance of the product forecasts since they... |
|
| 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 ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
