azure-sql-database
SQL Azure not recognizing my clustered Index
I get the following error when I try to insert a row into a SQL Azure table. Tables without a clustered index are not supported in this version of[详细]
2023-03-31 14:32 分类:问答Why does a SQL Azure DACPAC upgrade (via a PowerShell script) consistently take 30min to complete
I created a PowerShell script to upgrade a SQL Azure instance with my latest DACPAC (taken from http://msdn.microsoft.com/en-us/library/ee634742.aspx).[详细]
2023-03-31 08:12 分类:问答using temp tables in SQL Azure
I am writing a query to pivoting table elements where column name is generated dynamically. SET @query = N\'SELECT STUDENT_ID, ROLL_NO, TITLE, STUDENT_NAME, EXAM_NAME, \'+[详细]
2023-03-27 20:54 分类:问答How do I address sudden loss of connection to SQL Azure in my Azure role?
My Azure role grabs stuff to process from a database - it holds an instance of System.Data.SqlClient.SqlConnection and periodically creates an SqlCommand instance and executes an SQL query.[详细]
2023-03-27 13:57 分类:问答Query with a UNION sub-query takes a very long time
I\'ve been having an odd problem with some queries that depend on a sub query. They run lightning fast, until I use a UNION statement in the sub query. Then they run endlessly, I\'ve given after 10 mi[详细]
2023-03-27 00:25 分类:问答Azure sharding plan for ecommerce site
I contribute to nopCommerce and I am looking to provide support for sql azure. I understand that if you decide to use sql azure, it must be for the rig开发者_运维百科ht reasons, mainly sharding, scal[详细]
2023-03-26 23:32 分类:问答what feature is missing in SQL Azure
SQL Azure seems pretty cool. Some things are not available in SQL Azure though. For example, you can\'t do switch database with a USE statement - which is pretty understandable.[详细]
2023-03-26 15:20 分类:问答What do the ASP.NET Universal Providers enable that the default sql providers don't?
Inside the readme file of the ASP.NET Universal providers NuGet package is this quote The SqlMembershipProvider, SqlRoleProvider, SqlProfileProvider classes that shipped in ASP.NET through version 4[详细]
2023-03-26 00:43 分类:问答SQL Azure Database Named Pipes Error
Up until last night, my site (hosted by DiscountASP.net) and the SQL Azure database that it connects to were running normally.[详细]
2023-03-25 08:53 分类:问答Alternatives to global temp table in Sql azure
A part of my sp contains following code .The code executes successfully in my local sql database . but when i run it in sql azure it gives the error saying:[详细]
2023-03-24 06:25 分类:问答