Viewing 15 posts - 4,591 through 4,605 (of 8,416 total)
PaulB-TheOneAndOnly (3/30/2010)
March 30, 2010 at 2:27 pm
Definitely compress first. Minimally-logged bulk insert into a compressed table (heap or clustered) is supported.
Inserting compressed data will be much faster than inserting the (presumably much larger) uncompressed data...
March 30, 2010 at 2:23 pm
CirquedeSQLeil (3/30/2010)
tosscrosby (3/30/2010)
Paul White NZ (3/30/2010)
WayneS (3/30/2010)
March 30, 2010 at 2:10 pm
Revenant (3/30/2010)
Well, the question is incorrect, anyway - RG is also available in the Evaluation Edition. So that "only" without this version mentioned is IMO misleading.
Not all that misleading...
March 30, 2010 at 2:06 pm
WayneS (3/30/2010)
Fellow Threadizens, if I can get you to check out this link about a sql login permission issue that I'm having, I would really appreciate it!
You should have marked...
March 30, 2010 at 1:56 pm
Peter Trast (3/30/2010)
Paul White NZ (3/30/2010)
This question made my head hurt.Isn't that normal?
I suppose it is - though for varying reasons. This one was good in that it was...
March 30, 2010 at 1:51 pm
Peter Trast (3/30/2010)
Impeccable logic Paul 😉
Given the bird theme, I suppose it should be im-peck-able logic really 😀
(sorry)
March 30, 2010 at 1:49 pm
Last thought:
Check out the super-handy function and examples:
Covering/Implied Permissions (Books Online)
That will show you all implied permissions at any level.
edit: Oh, and check that the database with Modify disabled...
March 30, 2010 at 1:35 pm
...and if you want a guess, I would say that the VIEW ANY DEFINITION is inherited from the ADMINISTER BULK OPERATIONS permission, since bulk insert requires checking the definition of...
March 30, 2010 at 1:23 pm
Dietmar Weickert (3/30/2010)
Still you must be lucky to get the same behavior as bitbucket.
Not sure really - I have just used this feature before, so recognised it in the question.
That...
March 30, 2010 at 1:19 pm
Hugo Kornelis (3/30/2010)
If there's one thing I've learned over the past years, it is to take everything that comes from Itzik VERY seriously! 😉
Agreed. He has a tricky habit...
March 30, 2010 at 1:13 pm
Dietmar Weickert (3/30/2010)
Does not work as described.Personally I do not like questions where the correctness of your answer changes with your luck.
Read the other posts here.
March 30, 2010 at 1:09 pm
You are just checking server-level (login) permissions.
Write a similar query to check the database-level (user) permissions.
Use sys.database_permissions and sys.database_principals
select perm.*
from sys.database_permissions perm
...
March 30, 2010 at 1:04 pm
Hugo Kornelis (3/30/2010)
I was not able to find any way to get the SELECT * to behave other than the SELECT 1
Me either! I tried indexes, scalar functions, XML...
March 30, 2010 at 12:56 pm
Hugo Kornelis (3/30/2010)
As far as I know, that was once the case. In SQL Server 7.0 or so.
It's still in Itzik's Inside SQL Server 2008 T-SQL Querying book 🙂
Do you...
March 30, 2010 at 12:31 pm
Viewing 15 posts - 4,591 through 4,605 (of 8,416 total)