Saturday, July 13, 2013

[SQL Server 2008 issues] Where is Left table in Left Join ???

[SQL Server 2008 issues] Where is Left table in Left Join ???

Where is Left table in Left Join ???

Posted: 22 Jun 2013 05:45 PM PDT

Hi all, I did my home work but just want to confirm where is that Left table on Left SQL :a. Very Firs mentioned in Selectb. on the Left side of equation in ON statement.Is this the same:Select T1.C1, T2.C2 From T1 Left join T2 on T1.C1 =. T2.C2vs.Select T1.C1, T2.C2 From T1 Left join T2 on T2.C2 = T1.C1. ------ note t2 first hereWhat if I do lef5 join on tables which are not on main select? In this case order could be determined from "=" line ?TxMario

removing linkedservers

Posted: 12 Jul 2013 02:13 PM PDT

Hi all,I have to remove some linkedservers which connects to oracle and pull data and I need to remove some of them. What is the proper way to remove these?Do I need to check before I drop or delete them? Please advise.Thanks,SueTons.

Connection problems?

Posted: 12 Jul 2013 07:30 AM PDT

We are having some connection issues with several items, but I am going to post just one and hope that it puts me on the right path.I am running a query that pulls data from a couple of linked servers. It has always ran fine but is now returning this:OLE DB provider "SQLNCLI10" for linked server "mainserver" returned message "Protocol error in TDS stream".OLE DB provider "SQLNCLI10" for linked server "mainserver" returned message "Communication link failure".Msg 65535, Level 16, State 1, Line 0Session Provider: Physical connection is not usable [xFFFFFFFF]. OLE DB provider "SQLNCLI10" for linked server "mainserver" returned message "Communication link failure".Msg 65535, Level 16, State 1, Line 0Session Provider: Physical connection is not usable [xFFFFFFFF]. OLE DB provider "SQLNCLI10" for linked server "mainserver" returned message "Communication link failure".Msg 10054, Level 16, State 1, Line 0TCP Provider: An existing connection was forcibly closed by the remote host.I started with saying that there is a network error, but the network people say that the network is fine (of course) and that it is an authentication problem. I don't see how. I am trying to find something solid to take back to the network people.Any help is appreciated.

Transfer The Logins and The Passwords Between Instances of SQL Server

Posted: 30 Jun 2013 11:09 AM PDT

we want to Transfer The Logins and The Passwords Between Instances of SQL Server 2008we have 78 logins and 78 database userswhat are the clear step by step of going by moving all the logins and users and fixing orphan users in concise manner thanks

handling errors in SSIS 2008

Posted: 12 Jul 2013 07:50 AM PDT

Hi every oneI'm working with SQLServer Integration Service 2008I have some questions about handling fails in SSIS:I have a package containing a data flow task, wich has some data flow sources, transformation, and destination, but without handling error the task stops displaying the error cause in the output window, the error message is very clear, like this: Hresult: 0x80004005 Description: "Violation of UNIQUE KEY constraint ...."When I try to handle the fails for logging messages, I try to capture manipulating "Oledb destination error output" looking for that error, but that message is hidden and always returns this ErrorCode -1071607685 with the message "Not status available", and the columnNumber is 0. That is the same for any sql server error occurs.I need to capture sql server errors from ssis package, code and message, not ssis package errors, this is for logging that messages in a database.Thanks for any suggestion.Jose Obregon

SSIS load?

Posted: 12 Jul 2013 06:42 AM PDT

When setting up a new SQL Server 2008 R2 is there any advantage to installing SSIS on a separate server to offload CPU and Memory from the SQL Server? I'm thinking that SSIS service doesn't do much other than manage the packages and monitor the execution of them and the actual ETL SSIS jobs where ever they get run against is where all the processing takes place. But my developers think otherwise. Please adviseThanks

Sending mail from On Prem server to Off prem exchange

Posted: 12 Jul 2013 05:20 AM PDT

Im having some troubles getting my SQL mail setup using an off premise exchange with office 365. I can get the server to send through googles smtp but cant get it to work with office365. Has anyone gotten this type of setup to work ? Ive found through searching that i may have to setup an SMTP server locally to route to the online exchange ?? Below is a link to a description.[url=http://blogs.technet.com/b/meamcs/archive/2013/02/25/how-to-configure-sql-database-mail-so-send-emails-using-office-365-exchange-online-a-walkthrough.aspx][/url]

SSIS to the rescue, Replication, or overkill?

Posted: 12 Jul 2013 12:38 AM PDT

Question - I need to pull data from our internal SQL Server Database, create a few derived tables which are truncated and repopulated daily, and get this data out to our public web site in a set of identical tables. The tables on the web site match identically in design to the tables which are derived on our internal servers. So the daily flow is this:(1) Multiple intenral tables >> Views & Stor Procs >> (2) Truncate and Populate Derived Tables >> (3) Get data out to web site in matching tables. The method I'm using to populate the web site tables is I am deleting all the records in these dummy tables and Importing the data through SSMS Wizards. So far, so good. This is beta web site and it is only day 2 of this process so it's still all new. I can easily do this through SSMS because I can [b]connect[/b] to both our interal database and the one residing on the web hosting servers. So my question is this - although I haven't tried yet, wouldn't it make sense just to eliminate the Derived tables I am populating daily in step 2 and just get that data out to the web site to THOSE tables directly? As long as SSMS is connected to both SQL Server databases, this should be possible through a Stored Procedure right since I can do it manually through Import/Export Wizards.If this is true the I suppose it's just a matter of syntax in the Stored Proc right??Thoughts? Advice?

SSIS in cluster

Posted: 12 Jul 2013 03:53 AM PDT

I have two nodes nodeA and nodeB on a sql server on a fail over clustered environment. Each of these nodes have two sql server databases that I am interested in. I need to deploy SSIS packages to this cluster environment using XML configuration and file system deployment. Now in the config file i am not quite sure which node names(server names) i should use because the nodes name should switch when a failure occurs? Please advise.

System databases backup retention policy

Posted: 12 Jul 2013 12:40 AM PDT

HiMy question is rather a general one and i appreciate there will be a difference in the answers depending on peoples environments.My questions is "How long should you keep your system database backups if you are backing them up once a week ?"On our servers we are keeping them for a 5 month period - i think this is too much as if there was a failure of the master database surely we would just use the most recent backup. Im thinking of changing the retention to just 4 weeks and saving some disc space !!

completely uninstall SQL 2008

Posted: 12 Jul 2013 01:51 AM PDT

I am trying to completely uninstall sql server 2008 from my computer.i removed all files from control panel,removed directories but its still there

Impact of DBCC UPDATEUSAGE (0)

Posted: 03 Jul 2013 08:17 PM PDT

We got the advice to run DBCC UPDATEUSAGE, on one of our databases.What impact can be expected from this command?[b]Can this be done online?[/b]Does this impact the servers performance?This is for a 2005 system, databasesize is 40 Gb.On a 2008 system a comparable database of 10 Gb was done in 10 secs.On a 2008 R2 system (small) a 200 Gb database was done in just under 6 minutes.Test for a 2005 system on the backup of the database is in preparation.thanks for your time and attention,Ben Brugman

Fail Over Clustering Question

Posted: 11 Jul 2013 11:39 PM PDT

I will build up to the question...If we have a two node Active/Active fail over cluster set up like the following:Node1:Server Name - CLSQL01SQL VCO - SQLBox1Instance Name - SQLBox01Database - DB1Node2:Server Name - CLSQL02SQL VCO - SQLBox2Instance Name - SQLBox02Database - DB2Our Connection Strings in the web.configs would like this:Provider=SQLOLEDB;Server=SQLBox1\SQLBox01;Database=DB1;Uid=User1;Pwd=Password123;ANDProvider=SQLOLEDB;Server=SQLBox2\SQLBox02;Database=DB2;Uid=User2;Pwd=Password321;In the situation of a failure, it is my understanding that the whole instance will fail over to the other node, be it 1 database or 10 databases. Using the information above, if SQLBox2\SQLBox02 has a failure and and that instance fails over to Node 1, that should change the second connection string to the following:Provider=SQLOLEDB;Server=SQLBox1\SQLBox02;Database=DB2;Uid=User2;Pwd=Password321;If this were to happen, it is my understanding that all of this automatic, but how does the web.config know that there was a failure and needs to change its connection string? My understanding has been that there will be a "Cluster Name" (for lack of better of term) that will be in the connection string that knows of both SQL Instance's and in case of a failure the web.config does not care what Node it is running on.In the above situation, how does the application/web.config know to change the server portion of the connection string?Thanks in Advance for your Help!

Help in BCP load failure.

Posted: 12 Jul 2013 12:38 AM PDT

We are loading a flat file ( Pipe delimited ) , till today if file had any issues , load failed with error and NO record(S) loaded to processing table. But today we had a BCP failure (due to right truncation error , file has 26 records) and just one record loaded and errors logged in log file. Just wondering how one record loaded when BCP file load failed. My understanding is BCP command will not load a single record if file had any issues ( format / length of columns is greater than specified column size in destination table ) , Can some one help here?

SQL Server Monitoring Tools: ManageEngine Free SQL Health Monitor 1.0

Posted: 11 Jul 2013 11:58 PM PDT

Has anyone used ManageEngines free monitoring tools for SQL Server?Free SQL Health Monitor 1.0If you have worked with it could you please share your opinion regarding this software.Thank you.Mark G.

SQL server windows authentication through network

Posted: 11 Jul 2013 11:22 PM PDT

I am using sql server 2008 r2.There are about 50 pc in my office connected in network.In a sql server 2008 r2 express(installed in windows 8) i have created all users windows account with same name as their name in their pc and then created windows authentication user in sql. Now all the users are able to connect to sql server using windows authentication. but now i am trying to do same for the another sql server 2008 r2 express which is installed in windows xp sp3. But it is not working when i try to connect to sql server using windows authentication from network pc message comes like "Login failed for user 'PC91\Guest'. " It is not recognizing the windows account of my pc. why it happens? Please tell me a solution.

SQL Agent job fails for powershell script

Posted: 11 Jul 2013 08:09 PM PDT

Hi everyone.I have a powershell script that outputs to .xlsx file.Works fine in Powershell, no issues.However when I try to schedule it as an SQL agent job it fail.Agent account running with permissions to dir where .xlsx to be saved.Script does shut down Excel when completed. This is the error.The error information returned by PowerShell is: 'Exception calling "SaveAs" with "1" argument(s): "SaveAs method of Workbook class failed"Had a look around but can't seem to find a solution. Any adivse gratefully recieved.cheers

SQL Server trigger on nonupdateable, non indexed views

Posted: 11 Jul 2013 10:39 PM PDT

Hi,so here is my problem.I have a two databases that are physically separated - one is in the US and one in Europe.In the US database I have 3 tables that, via a query, produce data for 1 table in the Europe database. The Europe database table is not updateable.I would like that when one of the fields in those 3 tables in the US get updated, inserted or deleted, the change is automatically reflected in the Europe database.I have been informed that I cannot use replication.I can create a view in the European database which shows me exactly the content the US tables in the exact way that I want them to appear on the table however I cannot get the program to use the view because it would be very slow to search. Hence I came to the conclusion that I need a trigger that updates the table whenever the content in the view is changed.I cannot use indexed views as this is not in the same database system. I also tried using an instead of trigger but it is not firing off.Can someone let me know what next to try?Thanks,N
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog