Hot answers tagged sql-server
Specifically, it appears to be a Fredrix Canvas Pliers #7400 tool. Here's a link to the manufacturers page (scroll to the bottom) Fredrix Canvas Pliers tool manufacturer: and a vendor page with a picture that more closely matches the book cover, Fredrix Canvas Pliers tool for sale. It looks like the spring has been removed from the tool on the book ...
Service packs and CUs do not change user databases. What is changed is binaries and system databases. Sometimes, database that are not strictly system databases but are shipped by microsoft are changed as well via upgrade scripts (sysutility_mdw, SSISDB, distribution...)
These are query planner warnings. In the actual execution plan (perhaps not the estimated one) I would expect to see a "warnings" section listing what the planner/engine is concerned about. A common warnings are when an operation spills data to disk or was wanting index statistics that were unavailable. The most common warning is for apparently missing ...
If you right-click on the warning -> properties you should see some Warnings:
The indexes are similar but not identical. The order of the columns in an index matters - a lot - and affects what queries might benefit from them. We don't know your queries but for example a query like the following would benefit most from index A: SELECT TOP (3) ChannelSKUID, Checked, SalesRank FROM dbo.SalesRankCheck WHERE ChannelSKUID = 'XXX' ORDER BY ...
Likely your database (the one your are attempting to restore/replace) currently has open connections. Try this logic: ALTER DATABASE <yourdatabase> SET SINGLE_USER WITH ROLLBACK IMMEDIATE; RESTORE DATABASE <yourdatabase> FROM DISK = "D:\Backups\BackupFile.Bak" WITH REPLACE, RECOVERY; ALTER DATABASE <yourdatabase> SET MULTI_USER; ...
Large Pages change allocation of memory from 4KB to 2MB (normally), which means that the TLB (translation look-aside buffer) is improved in the CPU increasing the performance. I've successfully used Trace flag 834 on production server in VMware for over a year. One important part before enable trace flag is that in VMware you should reserve at least the ...
This should do it if you are using Microsoft SQL Server: CREATE VIEW SomeView AS SELECT ID, ORDER, ASSEMBLY FROM Tab_A a WHERE NOT EXISTS (SELECT NULL FROM Tab_B b WHERE a.ID = b.ID); If you want to know how many are different, then: SELECT COUNT(*) FROM SomeView;
You can certainly use source control and create a repo for storing scripts in a similar way to the way you store code. However, I'm a big fan of WIKIs for this- it also gives you a platform for other documentation. Check out Confluence.
We've used SVN for this, seems to be quite popular as several companies I've spent time with used it. You should be able to control who can and cannot write/update files, as well as who can see what. And one of the more popular clients is Tortoise, as vercelli mentions.
No, that's what snapshots are for: a static copy of the database at a specific instant. If you update the base database, the updated data pages are moved from the base database's data files to the the snapshots data files, with a "copy on write" operation, so that the snapshot always contains the same version of the data as when it was created.
Only top voted, non community-wiki answers of a minimum length are eligible