Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with sql-server
Search options not deleted
user 6390
All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.
1
vote
what is the difference between db_datareader and db_denydatawriter?
I think a real-world example of when you would use the db_denydatawriter role will help.
One of my clients has a third-party vendor assisting with a long-term (2-year), fixed scope project. The vendo …
- 432
4
votes
Best practices for transferring data across long, wide tables
Have you considered adding a ''rowversion'' column to your source tables?
The simplest way to think about rowversion (formerly timestamp in SQL Server) is as a database-wide autonumber. Every INSERT …
- 432
5
votes
Connection to localhost dramatically slower than to network server
Try enabling TCP/IP on your local instance:
Open SQL Server Configuration Manager (mmc.exe -> [Ctl] + [M] -> Add "SQL Server Configuration Manager" snap-in)
Expand "SQL Server Network Configuration" …
- 432
6
votes
1
answer
2k
views
Any reason not to add 'rowversion' column?
The TechNet article, "Optimizing Microsoft Office Access Applications Linked to SQL Server", recommends adding a rowversion column to SQL Server tables linked from MS Access. From the Supporting Conc …
- 432
2
votes
Column definition for a SQL Server equivalent to Access BOOLEAN type
This will do it:
MyField smallint NOT NULL CONSTRAINT MyField_YesNo CHECK (MyField = 0 OR MyField = -1)
- 432
6
votes
2
answers
6k
views
Column definition for a SQL Server equivalent to Access BOOLEAN type
The BOOLEAN datatype in Access (ie, Jet/ACE) returns a -1 for True and 0 for False; the field is always required (i.e., it cannot be set to NULL). The SQL Server BIT type returns 1 for True and 0 for …
- 432
3
votes
Semi-Annual archiving of SQL Server database
Restore From Backup --> [Drop Unused Tables]
Perform a full backup of database ProductionDb.
Restore from backup to database ArchiveDb2011B.
[optional] Drop unnecessary tables.
Set database ArchiveD …
- 432
0
votes
Semi-Annual archiving of SQL Server database
Use Database Snapshots
Use SQL Server's built-in Database Snapshot functionality. In the article on Typical Uses of Database Snapshots, the following is listed as a common use case:
Reasons to take …
- 432
0
votes
Semi-Annual archiving of SQL Server database
Create Table Structure --> Fill Tables --> Add Security
Use SSMS to generate scripts to create table structures.
Change the USE [ProductionDb] at top of each script to USE [ArchiveDb2011B].
Create t …
- 432
3
votes
3
answers
644
views
Semi-Annual archiving of SQL Server database
Twice a year we create a static, archived subset of our production database. The newly created database contains roughly half of the tables as the production db (log/audit tables, etc. are not copied …
- 432