One of the most important design decisions that must be made when planning deployment of Azure Cosmos DB involves logical partitioning of data that will populate target collections, graphs, or tables. Selecting the optimal partitioning model has both performance and pricing implications. In this article, we will explore the rationale behind these implications and review the partitioning options.
2018-03-08
2,357 reads
Azure Cosmos DB is the latest data service offering from Microsoft. Azure Cosmos DB is a super set of DocumentDB and provides a new set of capabilities. These capabilities make Azure Cosmos DB stand out from other members in the NoSQL database family.
2017-09-05
3,084 reads
2005-05-25
>>I've tried it the logical way by selecting to execute task and the typing 'exec sp_....' and this obviosuly does not work. It's pretty obvious that it does work, hence the large button at the bottom of the ExecSQL task UI labelled "Parameters".What are you trying to pass into the sproc as parameters ? Global DTS variables […]
2005-04-15
This is why I'm not a fan of using Maintenance Plans. I much prefer to code all the jobs myself so I get detailed output. When I'm in DBA mode (I'm currently doing SQL development) I use ISQL to run my DBCCs and pipe the output to a text file. It's run as a batch […]
2005-04-15
Just give me a few years Frank and I'll join in on that competition . Congrats on the MVP title.
2005-04-08
You state that the cpu levels are at 100%, is the task manager showing that it's SQL that using that cpu, or is there another process?
2005-03-23
i would bet that a connection string is incorrect when it is moved to production...I don't know your app of course, but if the connections string is hardcoded to look for a specific machine name, ip address, database name, then it might fail;check the basics of the connection string:from the production machines perspective,does the server […]
2005-03-16
1 reads
My guess would be that there would only be extra overhead when the RaiseError was invoked (Maybe not even then).You could test it by running a script without any RaiseError statements then adding the RaiseError statements and comparing the results. If the timings are the same with no errors conditions, then you should be okay. Hope […]
2005-02-14
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers