Comments
Sort by recent activity
There were changes to the formatting, especially the defaults. However, you should have control over those alignments, way more than before. Click on the SQLPrompt menu and then "Edit Formatting Styles..." to get started. / comments
There were changes to the formatting, especially the defaults. However, you should have control over those alignments, way more than before. Click on the SQLPrompt menu and then "Edit Formatting St...
OK, there's a lot to this. Best recommendation, check out the documentation located here. What you're looking for is Build. That's the one that's going to let you do the comparison and generate scripts and output. Sync will actually do the move after you've completed the Build. Come back here after you check that out if you have more questions.
As to C#, I don't know. I've only done this work using PowerShell and the examples will show that. I'll see if I can get someone to show that for you.
You can pass in a filter to the Build process.
You can distribute the artifacts you generate, but if you need to do a compare to each of the clients to generate that artifact, that's tougher. We'd need to drill down on what you're doing, why and how. / comments
OK, there's a lot to this. Best recommendation, check out the documentation located here. What you're looking for is Build. That's the one that's going to let you do the comparison and generate scr...
To validate this works, I just connected an Azure SQL Database to my Team Foundation Services source control. Everything ought to work.
Make sure you have the latest version. I think some of the older versions had a problem with Azure. / comments
To validate this works, I just connected an Azure SQL Database to my Team Foundation Services source control. Everything ought to work.
Make sure you have the latest version. I think some of the ol...
It’s pretty straightforward. You have a “Sql Prompt” menu in SSMS or VS. Click on that and then select “Edit Formatting Styles”. It’ll open up the new editor. It’s really slick. You can edit the default style or create a new one. I’d go for creating a new one to start. Then just step through all the different options and save the work when you’re done. As you make changes you can see a sample query or even preview the current query. It makes it really easy to get exactly what you want in terms of style. We even have a nice article telling all about it.
Hope that helps / comments
It’s pretty straightforward. You have a “Sql Prompt” menu in SSMS or VS. Click on that and then select “Edit Formatting Styles”. It’ll open up the new editor. It’s really slick. You can edit the de...
This looks like some kind of bot defining two terms, not even remotely answering the question. / comments
This looks like some kind of bot defining two terms, not even remotely answering the question.
Not a problem. I'm here to help out. / comments
Not a problem. I'm here to help out.
Yes. If you go into the Alerts management window, on the left side of the screen you'll see your servers. You can drill down to an instance and then drill down on the instance. You'll see a list of databases. Scroll down and you'll see a list of Jobs that can be expanded. Select the job you want to modify and you can control it at that level. / comments
Yes. If you go into the Alerts management window, on the left side of the screen you'll see your servers. You can drill down to an instance and then drill down on the instance. You'll see a list of...
So that's cumulative query time. That database may in fact be the problem. You still don't know that 100% because the query is assigned to the database that calls it, but that query could be calling other databases. It's just this odd point that makes a perfect, "Well, yes, of course that particular database is the one using your CPU resources" difficult to say with certainty. It depends on the queries.
That said, the queries from that database are absolutely the top cost of CPU on your system. We can say that with 100% certainty.
Does that help? / comments
So that's cumulative query time. That database may in fact be the problem. You still don't know that 100% because the query is assigned to the database that calls it, but that query could be callin...
1) There's not really a ranking by database of CPU usage. In fact, the way SQL Server works, it's going to be difficult to identify that for certain because any given query could be running from one database while querying another. Which database do you put the CPU use into? You can look at transactions and other database specific metrics. Some are on the overview page and a whole bunch more are available in the Analysis page.
2) That's front and center on the Overview page. Scroll down from the sparkline one the server and you'll see a list of the current top 10 queries. You can resort that list by any of the provided columns. You can also go back in time to look at previous periods. That should show you what you're looking for. Further, clicking on the query will show you the waits for that query and you can look at the execution plan. Between the two, you get a lot of guidance on what to do to address the slow queries or the queries consuming lots of resources. / comments
1) There's not really a ranking by database of CPU usage. In fact, the way SQL Server works, it's going to be difficult to identify that for certain because any given query could be running from on...
Did you set up data purging? If so, what are the rules you have on your system? If not that, is it possible someone has access to the database and could be deleting data? / comments
Did you set up data purging? If so, what are the rules you have on your system? If not that, is it possible someone has access to the database and could be deleting data?