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 11530

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.

9
votes
2answers
I have users seeing a linked server which they are not supposed to see. The linked server is defined so that only I will have access to it, but everybody can see and use it. I have created the ne …
modified Feb 3 '16 by Paul White says GoFundMonica
2
votes
3answers
I have a certain table in my OLTP database, which is bulk-updated by several users. There is no way to know when they will update the table (somewhere between 5 times a day and once in a week). The …
modified Oct 14 '13 by Anup Shah
5
votes
You don't have to perform any task (destructive or non-destructive) at all. You can use the built-in function IS_SRVROLEMEMBER to find if a certain LOGIN is a memeber of the sysadmin server role: …
modified Jun 20 '13 by Roi Gavish
8
votes
There is no need to grant CONTROL on the schema. The permission required to DROP SCHEMA is either CONTROL on the schema or ALTER ANY SCHEMA at the database level, and that is why your user was able to …
modified Jun 16 '13 by Roi Gavish
5
votes
Your problem begins and ends with statistics and estimates. I have reproduced your situation on my servers and found some interesting hints, and a workaround solution. First things first, let's tak …
modified Jun 5 '13 by Roi Gavish
4
votes
The FORMAT function is case sensitive As such, "mm" stands for minutes and "MM" stands for month. You can see a complete table of combinations and letter meanings here. This is the .NET article for …
modified Jun 2 '13 by Roi Gavish
2
votes
I don't think your reason justifies using this solution (sisyphean labor is part of a programmer's life...) It is not efficient and i would not recommend it in your situation. If, however, your aim wa …
modified Jun 2 '13 by Roi Gavish
1
vote
Please try the this code: (it creates a stored procedure which will return what you need) CREATE PROCEDURE [dbo].[GetProjectInfo] @Project varchar(100) AS DECLARE @command NVARCHAR(MAX) SELEC …
modified May 20 '13 by Roi Gavish
2
votes
Your best option (considering your limitations) is probably using OPENROWSET with a FORMAT FILE Take a look at those links: Use a Format File to Bulk Import Data You can use the BCP utility once …
modified May 15 '13 by Roi Gavish
1
vote
SQL Server allocates disk space for a file (.mdf or .ldf) when the space is needed (according to your settings of course), then the file remains the same size even if transaction log (.ldf) is cleared …
modified May 12 '13 by Philᵀᴹ
5
votes
The answer is - you have to test it to find out. I did a test of my own on a table which has ~8,000,000 rows DECLARE @date DATETIME SET @date = GETDATE() ; SELECT T.DateCol, DATEADD(dd,-100,@date) FR …
modified May 7 '13 by Roi Gavish
0
votes
I personally don't like free tools messing with my databases... like others said before me, the best tool for comparing is Redgate Compare (another option from Redgate is their new Source Control - if …
modified May 2 '13 by jcolebrand
3
votes
You have declared the alias da2 inside a subquery, then you referenced it outside of that subquery, where it is not recognized. if you need "The last 2 AND's" as a filter of table T (the records th …
modified May 2 '13 by Roi Gavish
9
votes
I suggest the following code to prevent it from happening: (Instead of the code you posted in your question) DELETE FROM dbo.table GO IF EXISTS ( SELECT * FROM sys.identity_columns W …
modified Apr 29 '13 by Roi Gavish
3
votes
Try this option, there is a half-chance that SQL Server will behave differently... CREATE PROCEDURE [dbo].[sp_MemberIdsFromUserIds] @dtUserIds UNIQUETABLE readonly AS BEGIN SELECT userID, …
modified Dec 17 '12 by Roi Gavish

15 30 50 per page