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
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
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 Search options user 39083

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.

0
votes
For most typical implementations of SQL Server (e.g. all objects are stored within the dbo schema), I cannot think of a permission set that will allow you to do this without the inclusion of some DDL …
answered Jul 3 '17 by John Eisbrener
1
vote
It sounds like you are looking for an Entity-Attribute-Value (EAV) data model design. Aaron Bertrand has a great post on this which I suggest you look through and see if a similar approach will fit y …
answered Jun 6 '17 by John Eisbrener
1
vote
This is a bit kludgy as I was unable to get a windowing function (i.e. DENSE_RANK, NTILE, RANK, or ROW_NUMBER) to work like I had hoped, so I had to "design" one via COALESCE and some customizations w …
answered Jun 22 '16 by John Eisbrener
1
vote
The database engine thinks you're trying to perform a piecemeal restore using the UI. This is the formal name of restoring individual filegroups. Sadly, it requires you restore the entire database t …
answered Jul 17 '17 by John Eisbrener
0
votes
This may work for you, but by no means do I consider it elegant (or even good for that matter). First, configure the server to log all successful and failed logins. USE [master] GO EXEC xp_instanc …
answered Jun 19 '17 by John Eisbrener
2
votes
Since it sounds like you purged data from you tables, the next step is to release the free space within the datafile (.mdf) back to the OS. You can do this via a DBCC SHRINKFILE statement. If this d …
answered Jun 27 '17 by John Eisbrener
1
vote
I can't come up with anything better than building out a Dynamic SQL Statement for what you're trying to do. This is neither easy to read nor efficient in execution, but it should do what you want an …
answered Jul 12 '17 by John Eisbrener
1
vote
Just a guess, but I suspect someone likely only wanted to manage one backup file without thinking of the consequences if it became corrupted. This approach does backup the TLogs, so you can recover f …
answered Aug 4 '17 by John Eisbrener
1
vote
It may be too late now, but while you're tuning the new query execution plan, you may be able to grab an old plan from cache and force it's use via the USE PLAN query hint. This wouldn't be something …
answered Jun 21 '17 by John Eisbrener
10
votes
The key differentiator between the recommended locations (e.g. local storage, a SAN, or an iSCSI-based network) and a network share is quite simply, redundancy. All of the recommended approaches prov …
answered Sep 8 '17 by John Eisbrener
1
vote
If you can adjust the datatype of the column to XML and your table has a clustered primary key, you can potentially improve performance, but there are a few fundamental changes you'll need to ensure o …
answered May 7 by John Eisbrener
0
votes
This article can run you through the basics of getting this configured to your liking. Be warned, you may need to enlist the help of resources within your organization with elevated rights on the dom …
answered Nov 16 '16 by John Eisbrener
2
votes
I fully expect down-votes for this because my opinion doesn't fit convention in the SQL community, but I don't think you should be focusing on fragmentation levels nor should you be adjusting the fill …
answered Apr 10 '17 by John Eisbrener
1
vote
You can join the pivoted table to an aggregate of the base table, but there's a catch here: if you're missing a record for a given month (i.e. C0001 is missing a record for 2019-08-01), it will not co …
answered Aug 29 by John Eisbrener
1
vote
I'm not a big fan of the new format myself, but in this scenario, you'll need to Google/Bing it out. I suspect this is the link you're looking for: https://msdn.microsoft.com/en-us/library/ff878253( …
answered May 15 '17 by John Eisbrener

15 30 50 per page