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...
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
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...
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
March 17, 2013 at 1:27 pm
kevaburg (3/17/2013)
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
March 17, 2013 at 12:46 pm
kevaburg (3/17/2013)
He...
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
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...
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
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...
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
March 17, 2013 at 12:26 pm
clintonG (3/17/2013)
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
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...
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
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...
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
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...
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
March 16, 2013 at 12:18 pm
Did you read all the certificate-related pages in Books Online?
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
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.
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
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...
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
March 16, 2013 at 4:28 am
ratheesh4sql (3/16/2013)
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
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...
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
March 16, 2013 at 2:46 am
Viewing 15 posts - 13,846 through 13,860 (of 49,552 total)