Viewing 15 posts - 2,296 through 2,310 (of 49,552 total)
Your string literal need to be NVarchar, not Varchar.
@query shouldn't be in quotes, you want the executesql to execute the contents of that variable, not to try and execute the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2016 at 7:07 am
Grant Fritchey (9/30/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2016 at 6:20 am
Your string literals need to be NVarchar, not Varchar, so N'string contents' rather than just 'string contents'
Also, @query1 shouldn't be in quotes, you want the executesql to execute the contents...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2016 at 3:54 am
Mike Scalise (9/30/2016)
Are you suggesting then that there's no easy way to shrink this log back to its initial size?
No.
I said that an active VLF can't be moved. To...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2016 at 3:41 am
Log backups *and* additional write activity on the DB such that the active VLF wraps around. You can't move VLFs, and you can't ever make the one that's active and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2016 at 1:54 am
ils_83 (9/29/2016)
hmm i thought OS RAM requirements only around 4GB, that's why i only give 6GB
The minimum RAM requirement for installing the OS is 4GB. Windows needs memory to manage...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2016 at 1:52 am
The general guideline is to ignore tables under 1000 pages. Fragmentation only affects large range scans from disk, not general operations against pages in the buffer pool.
Make sure you're doing...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2016 at 10:26 am
For 2, try a google search for database permissions
For 3, try a google search for fixed server roles and database permissions
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2016 at 10:24 am
You grant ALTER on the schema, then the required CREATE permissions at the DB level, make sure the user has NO permissions to the dbo schema, doesn't have DB_Owner, doesn't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2016 at 9:40 am
You can pass parameters to and from sp_executesql. See: https://msdn.microsoft.com/en-us/library/ms188001.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2016 at 8:10 am
Cool, so you have a working GRANT statement for the schema, based on the permissions listed there?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2016 at 8:06 am
Welsh Corgi (9/29/2016)
GRANT ALTER PROCEDURE TO CCUser;I have the same problem with DROP PROCEDURE.
Have you even bothered to read the linked page?
The page that lists EXACTLY what are valid...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2016 at 7:36 am
Phil Parkin (9/28/2016)
See link.
And, after you're read that, tell me whether 'CREATE PROCEDURE', 'ALTER PROCEDURE', 'DROP TABLE', etc are valid permissions to be granted on a schema.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2016 at 7:15 am
What's the error?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2016 at 7:04 am
Oh, and don't select *, specify just what columns you need from the PADQ table
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2016 at 6:21 am
Viewing 15 posts - 2,296 through 2,310 (of 49,552 total)