Viewing 15 posts - 166 through 180 (of 432 total)
Is the server used for something other than a SQL Server Engine Host? Is 3rd party vendor software also running? If the server has 16GB and SQL...
October 17, 2013 at 10:57 am
If the datababase is on SQL then only those in the sysadmin server-level security role, plus those giving security permissions to the database, will be able to view the data....
October 17, 2013 at 10:48 am
The following does work:
select convert(integer,'15')
Your example didn't work because data would be truncated. If you convert 2.9999 to 2 in an engineering for finance app the consequences can...
October 15, 2013 at 10:59 am
You may have two versions of the same prodecure in different schemas, as in dbo.sp_myproc and sales.sp_myproc.
I've been thrown by this confusion before.
Or if you have multiple *.bak files that...
October 15, 2013 at 10:20 am
If you don't need the .02xxx you can use
select convert(integer,ROUND('15.0271428571429',0))
October 15, 2013 at 10:12 am
I would try uninstalling using any Administrator accounts you have, preferably the one used for the initial install.
If that doesn't work, you can try deleting the Microsoft SQL Server folder...
October 11, 2013 at 10:08 am
What does the vendor in this case supply? Hardware? DBA services? 3rd party App?
I have a lot of experience supporting 3rd Party apps with...
October 11, 2013 at 9:57 am
I believe if you make this user Owner of the database that he should have access to, that overrides the deny view permission above and makes his database the only...
October 10, 2013 at 11:19 pm
Is this user in any of the Database Roles? If so remove it, and it will have only the permission you explicity added.
October 9, 2013 at 6:54 am
A busy server is going to have a lot of T-SQL batches completed in a short amount of time. I've successfully ran traces against busy servers while filtering...
October 9, 2013 at 6:13 am
Agreed - you have an earlier BEGIN TRANSACTION without a commit or rollback earlier in the code. When you have more than 1 BEGIN TRAN that hasn't been...
October 9, 2013 at 5:58 am
When running SQL Profiler be careful to set the filters to be as restrictive as possible while still capturing the data you're looking for. This will both minimize the...
October 9, 2013 at 5:48 am
Depending on the interviewer's definition of "query" it could be
BEGIN TRAN
UPDATE ADDRESS SET CITY = 'B'
ROLLBACK TRAN
October 9, 2013 at 5:22 am
"Have you tried turning it off and on again?"
If you're able to schedule a downtime, do it. Simpley stopping the SQL Service and restarting will return the TempDB to...
October 8, 2013 at 9:01 am
dogramone (10/3/2013)
I just use a concatenate and a right.So select right('00' + cast(1 as varchar) ,2)
Simple and makes sense. Thanks!
October 7, 2013 at 11:26 am
Viewing 15 posts - 166 through 180 (of 432 total)