Viewing 15 posts - 1,546 through 1,560 (of 13,469 total)
Gail alluded to the issue TOP 100 without an order by, or an insufficient order by that covers your desired results.
add more columns to your order by, and change the...
August 24, 2015 at 9:25 am
you can create a SQL job or a stored procedure with Execute As Owner.
the SQL job or procedure would contain the restore command in it,and you grant the...
August 24, 2015 at 7:16 am
you'll probably need to investigate a bit more ; could their reasons for it be simply institutional inertial(we always needed db_owner just in case)
if an application is using this login,...
August 24, 2015 at 6:01 am
coolchaitu (8/24/2015)
We want our app login(prduser) to have ONLY execute permission to procedures.It must NOT be able to ALTER or DROP stored procedure. It is allowed to do everything...
August 24, 2015 at 5:43 am
There is a neat technique where you sum a case with a counter to get this kind of information.
SELECT SUM(CASE WHEN placement = 'L' THEN 1 ELSE 0 END)...
August 23, 2015 at 4:55 am
mufadalhaiderster (8/21/2015)
C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf
I know this might sound...
August 21, 2015 at 11:21 am
for me, its keyboard shortcuts that point to procedures i marked as system procedures, that dig into the current database context of various system views;
they help me find objects, script...
August 21, 2015 at 8:14 am
service accounts don't expire, right? i know "regular user accounts", can have a domain expire date and a separate password expire date.
with Powershell, i've queries active directory to...
August 21, 2015 at 7:21 am
the [IN]/[NOT IN] (SELECT SOMECOLUMN FROM SECRETTABLE) has to explicitly exclude nulls.
NOT IN(SELECT SOMECOLUMN FROM SECRETTABLE WHERE SOMECOLUMN IS NOT NULL)
August 21, 2015 at 6:52 am
you have to create synonyms for anything that points to objects outside of the database.
the synonym will have deferred resolution,and your project will compile correctly, as you replace each three...
August 21, 2015 at 6:32 am
Not with a loopback.
using a linked server/loopback is going to require four part naming conventions. leaving out the database name would default to the default database of the user...
August 21, 2015 at 6:15 am
the biggest difference for me is that Developer comes with the SQL Agent, and thus the ability to create jobs. jobs are an important part of the DBA's toolkit.
Its important...
August 20, 2015 at 7:42 am
download SQL Express With Advanced Services. it's free.
http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx
that is the most complete version, and includes SQL Server Management Studio and more;
the "normal" express download does not include any tools, so...
August 19, 2015 at 2:01 pm
since you only want tasks that are not on hold, i'd look to get the data via the EXCEPT operator,a dn join it with the other items on hold.
nice job...
August 19, 2015 at 1:00 pm
Scots solution requires a mapping, mine is just assigning new values.
here's my version, the core is this part at the end:
;With
TheData
AS
(
SELECT
[dbo].[DelAlphaChar](vm.AccountNum) As CleanedNumber,
row_number() OVER...
August 19, 2015 at 11:25 am
Viewing 15 posts - 1,546 through 1,560 (of 13,469 total)