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 25995
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.
20
votes
Is it possible to estabilish Dedicated Administrator Connection (DAC) using SSMS?
This error occurs when you try to connect to DAC using the right click Connect and the Connect to Server dialog from the Object explorer
However, you can connect to DAC via SSMS by clicking the Dat …
11
votes
Identifying Unused Stored Procedures
You can find this question useful, it applies to tables and columns but suggests using a third party tool ApexSQL Clean which can also find unused stored procedures as well as all objects that are not …
8
votes
Figuring out the physical size of a group of tables in SQL server
You can use sp_spaceused stored procedure:
For example:
EXECUTE sp_spaceused 'Person.Person'
EXECUTE sp_spaceused 'Person.Address'
Gives you this:
Hope this is what you're looking for
4
votes
What is a good way to verify that a restore completed successfully in SQL Server?
As someone already mentioned in their reply running DBCC CHECKDB after a restore can be a good practice. This way as a backup is a copy of a db you will verify both backups and restores without any im …
2
votes
Visual Studio DAC with Schemabound View containing hierarchyid::GetRoot() - Two part name ne...
There are a couple of prerequisites to use the SCHEMABINDING option:
· You cannot use * in the SELECT clause in the query, you have to specify column names
· You have to use two-part …
2
votes
Copy encrypted database views
Here is one more solution that works on SQL Server 2012. You'll get the body of the view in the results.
Encrypting and Decrypting SQL Server Stored Procedures, Views and User-Defined Functions
HTH
1
vote
Large Table handling
Partitioning a table will help you in maintaining.
Here are some useful articles on maintaining a large table:
Handling Large SQL Server Tables with Data Partitioning
The only downside is that it o …
1
vote
SQL Server 2008 R2 Remote Connection issue
Are you using a named instance or a default one?
Did you enabled a remote connection on that instance?
Right click on the server and in the Server Properties dialog under the Connections tab check t …
0
votes
How to terminate BCP output with specific string AND newline?
Check Specifying Field and Row Terminators for bcp
E.g.:
-r \n -Specifies the row terminator as a newline character. This is
the default row terminator, so specifying it is optional.
Hope th …
0
votes
Identifying Unused Stored Procedures
This post also provides a script to find unused ojects: Find the unused database tables in SQL Server
Below is the script from the article, I changed table type "U" into stored procedure type "P":
…
0
votes
Script to generate insert statements
You can also use the bcp utility to import or export data.
In your case use something like the following command:
bcp "SELECT A, B FROM TEST" queryout Test.txt -c -T
To insert data from the file …
0
votes
Undo SQL UPDATE Azure DB
ApexSQL Log doesn't support SQL Azure because the transaction log file is differently handled in SQL Azure, and cannot be physically read by a tool.
I work in ApexSQL