Viewing 15 posts - 13,846 through 13,860 (of 49,552 total)
Or, instead of using the roles, you could GRANT SELECT, INSERT, UPDATE on the database instead.
Make sure that the login is not sysadmin, the user is not db_owner and you're...
March 17, 2013 at 1:47 pm
kevaburg (3/17/2013)
I understand to an extent your reasoning about allocating too much at the lower-end but too little at the top end?
Absolutely. The OS needs memory to manage memory, so...
March 17, 2013 at 1:27 pm
kevaburg (3/17/2013)
March 17, 2013 at 12:46 pm
kevaburg (3/17/2013)
He...
March 17, 2013 at 12:42 pm
TempDB files = 1/2-1/4 the number of cores, start with no more than 8, increase if you're still seeing allocation contention (and only split if you're seeing allocation contention to...
March 17, 2013 at 12:27 pm
kevaburg (3/17/2013)
Anyway, I use a practice of reserving 2GB for the OS and any applications that may be running independently of the database software.
Typically that's too much at...
March 17, 2013 at 12:26 pm
clintonG (3/17/2013)
March 17, 2013 at 12:25 pm
pooya1072 (3/16/2013)
but if i execute the sp , it's execue normal and i can show the result . what this mean?
It means that Management Studio's local intellisense cache is out...
March 16, 2013 at 3:29 pm
The query optimiser generates an execution plan, which in this case is a trivial plan that just contains the table scan and select operators. The query execution engine executes that...
March 16, 2013 at 12:30 pm
karthik M (3/16/2013)
How to identify whether a code fall under O(n) / O (n2) / O(n log n) by seeing the code ?
http://en.wikipedia.org/wiki/Analysis_of_algorithms
Should get you started. The list of...
March 16, 2013 at 12:18 pm
Did you read all the certificate-related pages in Books Online?
March 16, 2013 at 12:12 pm
You decrypt the entire column, re-encrypt with the new passphrase and change whereever that passphrase is stored in the app/stored proc.
March 16, 2013 at 7:58 am
That's not how partitioning works. Please go and do some reading on partitioning.
The sliding window method moves entire partitions from one table to another table. Emphasis on *move*. It's a...
March 16, 2013 at 4:28 am
ratheesh4sql (3/16/2013)
March 16, 2013 at 3:37 am
Replication between two databases on the same instance? Not sure why you'd want to do that, but collation doesn't prevent that, or any other SQL feature from working.
You can have...
March 16, 2013 at 2:46 am
Viewing 15 posts - 13,846 through 13,860 (of 49,552 total)