Tag Info

Hot answers tagged

7

There is a simple solution to this: Drop all of the _dta_... statistics and stop blindly applying DTA recommendations. More information The particular problem was that there were multiple sets of statistics for the column in question. The extra dta statistics were created by sampling the data (the default behaviour for statistics not associated with an ...


6

In order to understanding why error 3456 would be thrown, we need to take a little step back and understand how SQL Server handles this corner of recovery. When SQL Server is redoing an operation, and that redo is a page modification, it makes a quick check. In the page header there is ultimately going to be a PageLSN, which is an indication of the last ...


4

You can use charindex to find the first / and stuff to remove 5 characters. select stuff(Reporting_Week_Name, charindex('/', Reporting_Week_Name), 5, '') Data explorer


4

Yes there may be impact. To start with, you must read List of SQL Server features deprecated in SQL Server 2012 List of deprecated Database engine features in SQL Server 2012 Breaking changes to DB engine feature in SQL server 2012 You must run SQL server 2012 upgrade advisor and generate report before doing migration. This report would list out all ...


4

A SQL Server 2008 R2 mirror is not itself readable. If you are using Enterprise Edition, you can create a named snapshot database from the mirror. This allows you to create a point-in-time readable database that can be used for pretty much any query that does not do any updates. (Though you could use another database (tempdb or a workdb) to do auxiliary ...


2

This Powershell script should be able to solve most of your issue. I use a system table select to get my list of tables, then BCP to export all the data. The challenge is exporting your BLOBs. This script will export those as character data, which may not be useful to you in your situation. Import-Module sqlps -DisableNameChecking $outputdir="C:\TEMP" ...


2

I suspect that the DISTINCT is a performance barrier. I suggest you get rid of the duplicates (I would think that no device would ever be in 2 distinct locations at the same time, so a unique index on (imei, timestamp) would work just fine). Such a change may need changes in your application, so until you do get rid of the duplicates, you could use this ...


2

Edit - The below is assuming that the number of rows that would be returned by the query (if the limit wasn't present) exceeds the limit. (as in ... it regularly would return 5000 rows, but the limit forces it to return 1000) Any time you have a limit on the number of rows returned by a query, you should not expect the TIMING on that query to have any sort ...


1

No, it is nothing to be worried about - the Agent isn't considered a clustered service to SQL Server simply because it can't fail over on its own. You should test a failover and be confident that SQL Server Agent will start on the other node and that jobs will run etc. (sometimes there can be local dependencies that won't exist on the other node(s)), but ...


1

The problem lies in the referencing. You might have copied the package from an older one and are making the changes or you might have edited the connection managers. The connection managers are internally used using the GUID that you have mentioned. You might have changed most of the references from the UI, but still there are some objects and tasks, that ...


1

right(Itempath, charindex('/', reverse(Itempath))-1)


1

It was a problem about the database owner. Even if you can see an owner on this interface: Be sure that an owner is entered into files tab:


1

DECLARE @vcVar AS VARCHAR(500) = 'Week 3, 2011/2011/2012' SELECT STUFF(@vcVAR , CHARINDEX('/',@vcVar) ,5,'')



Only top voted, non community-wiki answers of a minimum length are eligible