Wednesday, October 9, 2013

[SQL 2012] creating user databases on ssrs server

[SQL 2012] creating user databases on ssrs server

creating user databases on ssrs server

Posted: 09 Oct 2013 03:31 AM PDT

Hi,Can I create an user database to hold the tables that will have data imported from multiple servers using SSIS package.I have 4 servers and I will get data from all the four servers and planning import all that data onto a user database on my reporting server for reporting purpose.Is that recommended?Thanks.

log shipping job failing any idea why?

Posted: 09 Oct 2013 04:09 AM PDT

Hi, Alllog shipping job failing any idea why?all jobs are failing thanks for looking

query performance vs server to server latency

Posted: 09 Oct 2013 03:48 AM PDT

I've tried running two different queries: one that was based on a much smaller query that didn't scale, and one that I thought would scale [i]better[/i], since it used a CTE to pre-process the data set to test. I've run both separately, and cancelled each after an hour. Both columns are varchar and neither is nullable. Running different portions of each query returns quick results. It's comparing ~56k rows to ~588k rows. The Thing That Shall Not Scale:[code="sql"]select a1.sam_batch, count(*) as Recordsfrom aww_sample a1,[p42].sample.dbo.wireless_blocks p2where substring(a1.sam_phonenumber, 4, 9) = p2.matchand a1.sam_batch between 437 and 449group by a1.sam_batch[/code]From Query To Eternity:[code="sql"]with cc(sam_batch, phone) as (select sam_batch, SUBSTRING(sam_phonenumber, 4, 9)from aww_samplewhere sam_batch between 437 and 449)select cc.sam_batch, count(*)from cc,[p42].sample.dbo.wireless_blocks p2where cc.phone = p2.matchgroup by cc.sam_batch[/code]So then I re-wrote things a touch and ran from the server with the larger table. It completed in 2 seconds (mostly) flat:[code="sql"]with cc(sam_batch, phone) as (select sam_batch, SUBSTRING(sam_phonenumber, 4, 9)from [phlsql].capabilities.dbo.aww_samplewhere sam_batch between 437 and 449)select cc.sam_batch, count(*) as Recordsfrom cc,sample.dbo.wireless_blocks p2where cc.phone = p2.matchgroup by cc.sam_batch[/code]Is there a smart SQL reason for this, or is the network the culprit?

Deriving a Session Number

Posted: 09 Oct 2013 02:57 AM PDT

Hi Guys,Could really do with some help trying to derive a field (session_number).I have a staging table which is populated with around 10 million rows daily, each day I need to identify the session number for each row by user_id.To identify the session_number we need to check if there is a gap greater than 5 minutes between the previous and current start_time.I have been able to do this on a small subset, but when dealing with the entire 10 million rows the database seems to process for days, any ideas?e.g.user_id start_time session_number123 09:00:00 1123 09:01:00 1123 09:02:00 1123 09:03:00 1123 09:09:00 2123 09:22:00 3Thanks,Rich

Enabling AlwaysOn on an existing HA Shared Storage SQL 2012 Cluster

Posted: 09 Oct 2013 02:44 AM PDT

Hi!I've searched numerous blogs and forums for the answer to this, but cant see to find any info on it (maybe i'm being blind!)We have an existing Windows Server 2008 R2 / SQL 2012 Enterprise 2-node Cluster with shared SAN storage.I'm looking at the possibility of creating a 3rd node, which wont have access to the shared storage.is it possible to enable AlwaysOn on the existing 2node cluster, and adding the 3rd node as part of the AlwaysOn availabilty group?I'm thinking it wont be possible but thought i would ask.many ThanksJames

Linked Server error 7357

Posted: 09 Oct 2013 02:41 AM PDT

We're in the process of moving a database from an old SQL Server 2000 instance to SQL Server 2012.Both servers have a linked server which connects to an Oracle 10g database to perform some data retrieval. On 2012, Oracle's ODBC driver is installed, System DSN set up and the linked server (named "ABC" below) tested - everything looks good. Some quick testing using OPENQUERY can select rows as expected.What isn't working is the execution of an Oracle function from a package. Executed from the 2000 instance it is successful and returns the data expected. Executed from the 2012 instance, the exact same code throws the following:[code]Msg 7357, Level 16, State 2, Line 1Cannot process the object "{CALL UB.WRAPADDR.CS2ADDR(1,'4310','E','TRENT','AVE',{resultset 10,ubaddr_ubilacct,ubaddr_buildingnumber, ubaddr_predirection,ubaddr_streetname,ubaddr_streetsuffix})}". The OLE DB provider "MSDASQL" for linked server "ABC" indicates that either the object has no columns or the current user does not have permissions on that object.[/code]Is there a configuration change I need to make on the ODBC DSN, or in the linked server? I don't believe it's a permissions issue - both 2000 and 2012 are using the same Oracle login and I (with sysadmin) get the error.

Partition Creation Time

Posted: 09 Oct 2013 02:37 AM PDT

Hi, using SQL 2012 Ent. Does anyone know if there is an easy way to get the creation time of a Partition from SQL server Metadata?

IBM iSeries DB2/400 Version 6.1.1 driver to install on SQL Server 2012

Posted: 09 Oct 2013 02:20 AM PDT

Hello all,I would like to know what ODBC driver is needed to install on SQL Server 2012 machine to gain access to DB2/400 Version 6.1.1. Thanks,Victor S.

Copy Only - Security Policy

Posted: 08 Oct 2013 11:42 PM PDT

Hi all,I'm looking to create a policy that will stop any manual backups being performed, unless they are copy only. I haven't had much success so far. Does anybody know if this is possible? Is there a facet for this?Cheers in advance

Silent Install Of 2 SSRS Instances With Same Service Account

Posted: 09 Oct 2013 01:00 AM PDT

Hello AllI am working on doing an automated silent install of SSRS and SQL Server. The silent install is meant to be generic so it can be quickly deployed so I use built in Accounts. So for Report Server I used RSSVCACCOUNT="NT Service\ReportServer" and for AGTSVCACCOUNT="NT Service\SQLSERVERAGENT". I know its not best practice but the goal is to get it installed automatically.In my testing I am using silent install using Config File. For the initial install it installs fine. When I try to do a second install(instance 2) it doesn't work. For the 2nd install the only thing I am changing is INSTANCE NAME and INSTANCE ID. I am seeing errors related to invalid accounts even though they are the same accounts that work for the first install. One error for example I see is:"The credentials you provided for the Reporting Services service are invalid. To continue, provide a valid account and password for the Reporting Services Service"My question is I guess can you use the same service accounts for multiple instances? Any other ideas why this would fail when you use the same config file but change only the instance details? Any help would be greatly appreciated.Thanks in Advance

SQL 2012 with Windows Server 2008 or Windows Server 2012?

Posted: 08 Oct 2013 08:15 AM PDT

We're looking at migrating some of our SQL Servers to SQL 2012 (mainly for the BI improvements), but I'm wondering if it's worth upgrading the OS at the same time from Windows Server 2008 to Windows Server 2012.I've been trying to find some articles giving what benefits SQL 2012 has running in Windows Server 2012 compared to Windows Server 2008 but have been unable to find anything.Does anyone know of anything?

AlwaysOn Availability Groups

Posted: 08 Oct 2013 11:10 AM PDT

I'm planning to set up AlwaysOn Availability Groups.Questions:1. Can one cluster node should be enoguh to configure AlwaysOn Availability Groups?2. The node hosting the secondary replica, must be part of same cluster as Primary?Thanks,

Getting a semaphore timeout error when executing a job

Posted: 08 Oct 2013 06:54 AM PDT

I'm copying our SQL Jobs from the old SQL 2005 server to our new SQL 2012 server. Every one that I've copied and run, so far, is generating the following error:[quote]A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) (Microsoft SQL Server, Error: 121)[/quote]This error occurs in just trying to get the SQL Job started - it doesn't even make it to step 1.I've looked this error up and see that there's a lot of potential causes for it, so yet, I get that it won't be easy to get resolved, but I've got to start somewhere. Especially since now that someone else is managing our server, I've got to know where to begin pointing them to get it resolved.

Using Power View in SQL Server Enterprise 2012

Posted: 08 Oct 2013 06:50 AM PDT

Hi all,I understand that PowerView forms part of the Enterprise edition of SQL Server 2012, which I just installed on my local machine. As I am very interested to test the BI capabilities (Reporting) of SQL Server 2012, I was looking for PowerView but can't seem to find it. Isn't it installed by default in SQL Server Enterprise 2012? Also, do I need to have Sharepoint 2010 also installed to be able to use PowerView?Thanks for your help!

How to recover a job that i deleted from job activity monitor

Posted: 08 Oct 2013 04:12 AM PDT

Hi, allI accidentally deleted the job that are created on primary and secondary data base when I was configured for log shipping.the backup job on primarythe copy job and restore job on secondaryis there a way to recover these jobs this is on sql 2012

Setting out Database Mail when Office 365 is involved

Posted: 08 Oct 2013 04:19 AM PDT

I'm trying to setup Database Mail in SQL Server 2012, but have come across a problem I don't know how to resolve. We've got a departmental email address, which I use for many of the SQL Jobs I've created and am migrating to this new instance of SQL 2012. At one point it asks for the server. We're now using Office 365 for our email. So, I have no idea at all what the server would be that I have to specify in Database Mail.Help please.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog