Friday, October 11, 2013

[SQL 2012] Find value of cell from header name and row name (like going down and across)

[SQL 2012] Find value of cell from header name and row name (like going down and across)

Find value of cell from header name and row name (like going down and across)

Posted: 02 Oct 2013 08:38 PM PDT

what I want is the value of cell just like where x meets y, going down and across what is the value in that cell.Thank you for your time

SQL Server Merge Web - Pull replication error

Posted: 11 Oct 2013 01:58 AM PDT

I have some problems with web synchronization for the Merge Replication. I repeated every step described here: http://technet.microsoft.com/en-us/library/ms151763.aspx but I have always the same error:Security Error ....Unable to connect to the URL [https://web3/SQLReplication/replisapi.dll] during Web synchronization Ensure that the URL login credentials to the Internet and the proxy server settings are correct and that the Web server is reachable., 00:00:02,0,0,,, 0..... From subscriber's InternertExplorerI try the url: [https://web3/SQLReplication/replisapi.dll?diag] and it works.I also have repeated this step [http://technet.microsoft.com/en-us/library/ms152511.aspx]. Can anyone help me?

HADR solution for DW DB of huge size on TBS

Posted: 10 Oct 2013 10:10 PM PDT

Hi Experts,In my environment we are hosting a new projects which is DW and also a very bulky DBs in TBs.> what type of HADR solution is available for fasttrack databases in MS SQL Server 2012?>what type of HADR is available for SQL serevr 2012 for this heavy DBs?PLease advice.

SQL Server Alert that will work for SSAS Proactive Caching Errors in Event Viewer

Posted: 11 Oct 2013 01:20 AM PDT

I have a SSAS cube configured with Proactive caching. Sometimes, there are facts that arrive just seconds before dimension data is available in the dimension structure, and SSAS fires the following error "[b][i]OLE DB error: OLE DB or ODBC error: Operation canceled; HY008[/i][/b]" on Event Viewer. After that, nothing more that implement proactive caching will work in that cube.I would like to create an Alert to notify to DBA about the error and so he can take an action to solve the problem as soon as possible.Has anyone tried something similar?

Not getting the email notification that I set up

Posted: 11 Oct 2013 01:10 AM PDT

I've got a SQL Job that runs once a way, every day at 7:30 AM. It's supposed to send me an email, upon successful completion, however it hasn't since we've migrated from SQL 2005 to SQL 2012. I'm pretty sure that I've got this setup correctly, but it's still not sending me an email upon successful completion. I have myself set up as an operator in SQL, it has the correct email address. So, what am I doing wrong?

Best way to configure jobs on AlwaysON

Posted: 25 Sep 2013 04:34 AM PDT

Hi,We are planning to configure AlwaysON with 3 servers. Two in the same datacenter with synchronous commit and automatic failover and the third one in a different datacenter as a DR with asynchronous commit. Now what is the best way to configure the SQL jobs like Reindexing, DBCC Checkdb, Update Statistics and other application related jobs. The reindexing, update statistics and Checkdb should only be run on the Primary and should we keep them enabled on the secondary also.

Application compatibility for SQL 2012 Always on, vendor question

Posted: 10 Oct 2013 10:24 PM PDT

[size="4"][font="Times New Roman"]We currently use a SQL 2005 server to host numerous databases for a selection of applications. As this is getting to end-of-life, we are looking to replace it with a new 2012 implementation and hoping to use Always On Availability Groups to provide some HA and DR capabilities. I want to check with the application vendors, (some of which are quire small), that their applications will still work if we move to such an environment. To this end I am creating a document which can be sent to them to ask if they support this, I expect it to read something like:-[/font][/size][size="3"][i][font="Arial"]We are intending to implement a new SQL server 2012 instance and may look to move the backend database(s) for your application [application name] to this. As part of this SQL installation, we also intend to utilise the 'Always On Availability Groups' feature, which means that connections to the database will be made through an 'Availability Group Listener'. To use this feature, connections must be made using TCP/IP protocol.1) Has the application [application name] been tested in this configuration?2) Do you support the use of this configuration of database?3) Are there any special prerequisites which we will need to have in place to support the use of your application in such an environment?4) Does your application support connection strings which use ports other than the default 1433?[/font][/i][/size][size="4"][font="Times New Roman"]Are there any glaring mistakes or omissions?Is there anything else I should be asking?Thanks for your input.[/size][/font]

SQL 2012 - Updating a field based on Row to Row Comparison

Posted: 10 Oct 2013 06:57 AM PDT

I have a table that contains dates and times. For example fields are Date, ExTime, NewTime, Status. I am ordering them based on a expkey field that makes them show in the right order. I am wanting to do a row by row comparison and compare the second row field of extime to the first row field NewTime. If extime < Newtime then I want to update status with a "1". And then travers through the table row by row where second row in the above example becomes the first and a new second is pull and used. Here is a sample of what I have now - but it is not hitting and working all all of the rows for some reason.{UPDATE tSET t.Status = 1FROM MyTable tCROSS APPLY (SELECT TOP 1 NewTime FROM MyTable WHERE ID = t.ID AND [Date] = t.[Date] ORDER BY ExpKey) t1WHERE t.Extime < t1.NewTime}This is not hitting all the rows like I want it to. I have the where clause comparing fields ID and Date to insure that the rows are attached to the same person. If the ID or Dates are not the same it is not attached to the same person so I would not want to update the status. So basically if the ID of Row 2 = ID of Row 1 and Date of Row 2 = Date of Row 1 I want to compare extime of row 2 and see if it is less than newtime of Row 1 - if so then update the status field of row 2.Any help in figuring out why this sort of works but not on all I would appriciate.

Removed SQL 2012 Instance from Cluster, now having Kerberos problems. Suggestions?

Posted: 10 Oct 2013 09:03 AM PDT

Interesting dilemma... we were having an issue with the Passive node of one of our SQL 2012 Active/Passive clusters (running on Windows 2008), and in working with Microsoft a clean-up script was executed which basically destroyed the cluster. The end suggestion was to uninstall SQL and rebuild the cluster, but I was able to pull the Cluster registry key from the Instance and start MS SQL outside of the cluster. All is working great, but now we're finding Kerberos issues with double-hops like with Integrated Security with SSRS or deploying SSIS packages. It's not picking-up the authenticated credentials and is instead using an Anonymous account. I've lisetd out the SPN info for both the server name and former Cluster name on the server, but I'm unsure of what to change or drop to fix this. Any suggestions?Thanks.

Bulk Data

Posted: 10 Oct 2013 06:57 AM PDT

HiWhat is the process to follow if we have to retrieve data to a tune of 50 million records from couple of different data sources[legacy and non SQL server] and store them into multiple csv files.What is the process to go about ..any example?Thanks

AlwaysOn backup dates for secondary backups

Posted: 10 Oct 2013 06:53 AM PDT

I'm not sure if anyone else has encountered this, but I'm not seeing the last backup dates updated on the Primary server of an Availability Group when the backups are being performed on the secondary. This seems like a bug to me, if you rely on those dates to verify the time of the last backup.The issue is that the backup data is recorded in MSDB on the local server, so the backup gets updated correctly on the secondary, and updates the secondary's backupset table, but you can't view it via the GUI, since you can't view the properties of the database on the secondary (even though it's read-only??)I can verify by running the following:select database_name, max(backup_finish_date) lastBackup from msdb.dbo.backupset where type = 'L' group by database_name;I take it that the restore process does not use the MSDB info as the last LSN differs as well on the primary and secondary, however, I have been able to restore databases using a full backup on the primary and secondary log backups with no problems.So, I suppose the only way to get a valid last backup date is to create a linked server to the other Availability Group nodes and join the backupset tables together on all the nodes to find the max(last backup).Any better ideas? It's too bad you can't add the MSDB database to the availability group. That would solve some other issues as well, like security changes.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog