Search Results

Search found 105755 results on 4231 pages for 'learn sql server'.

Page 224/4231 | < Previous Page | 220 221 222 223 224 225 226 227 228 229 230 231  | Next Page >

• Learn SSIS in London 12-14 Sep 2012!

  - by andyleonard

  My friends at TechniTrain , the students, and I had a blast during the March 2012 London delivery of From Zero To SSIS ! We have decided to do it again in September 2012 with my new Learning SSIS 2012 3-day course ! Please find a course outline here . It is difficult to list everything I cover in the course, but the outline hits the high spots. This material grew out of my experiences serving as a consultant on short-term engagements and as a manager (and enterprise ETL architect) for a team of forty...(read more)

  Read the article

• sys.dm_exec_query_stats interaction with recompilation

  - by Sam Saffron

  We use sys.dm_exec_query_stats to track down slow queries and queries that are IO offenders. This works great, we get a lot of very insightful stats. It is clear this is not as accurate as running a profiler trace, as you have no idea when SQL Server will decide to chuck out a an execution plan. We have quite a few queries where the wrong execution plan is cached. For example queries like the following: SELECT TOP 30 a.Id FROM Posts a JOIN Posts q ON q.Id = a.ParentId JOIN PostTags pt ON q.Id = pt.PostId WHERE a.PostTypeId = 2 AND a.DeletionDate IS NULL AND a.CommunityOwnedDate IS NULL AND a.CreationDate @date AND LEN(a.Body) 300 AND pt.Tag = @tag AND a.Score 0 ORDER BY a.Score DESC The problem is that the ideal plan really depends on the date selected (screenshot of ideal plan): However if the wrong plan is cached, it totally chokes when the date range is big: (notice the big fat lines) To overcome this we were recommended to use either OPTION (OPTIMIZE FOR UNKNOWN) or OPTION (RECOMPILE) OPTIMIZE FOR UNKNOWN results in a slightly better plan, which is far from optimal. Executions are tracked in sys.dm_exec_query_stats. RECOMPILE results in the best plan being chosen, however no execution counts and stats are tracked in sys.dm_exec_query_stats. Is there another DMV we could use to track stats on queries with OPTION (RECOMPILE)? Is this behavior by-design? Is there another way we can for recompilation while keeping stats tracked in sys.dm_exec_query_stats? Note: the framework will always execute parameterized queries using sp_executesql

  Read the article

• Joining a network with a Virtual Windows Server 2008 R2

  - by Triztian

  Hi all, here's my case, I have set up a share in a virtual windows server 2008 R2, the server is hosted by GoDaddy my question is, how do I access the server's public folders, I need to open a file locally (on the client) and to do that I need the server to show up in my Network locations, I have the right credentials and have created a special group that has access to the particular folder that I'm sharing the problem is I don't know how to add the server to my network locations. I have tried VPN Connection but it is my understanding that it cannot be done since it is virtual share server. Any help is trully appreciated.

  Read the article

• Slowness on Exchange 2007 Server (network related we think)

  - by Az

  We are seeing some odd behavior out of our exchange 2007 server. I believe it is network related as during the slowness in response from the exchange server. During these times downloading files to server is fraught with connection resets and extreme slow download speeds that are not affecting other servers right on the same subnet with the same gateway and ISP. We have about 50 users at a time using Outlook 2003 from a terminal server not displaying any other signs of slowness, all network slowness is confirmed trying downloads on the exchange server itself. Checked for virus issues, there are none. Checked for hardware issues, none found I am noticing between 200-400 TCPv4 connections established I am seeing around 100k tcpv4(active) connections according to perfmon are these numbers odd? Has anyone run into anything similar? Our server has a gigbabit NIC linked to a gigabit switch using cat6 so I do not believe it is "physical". Thanks!

  Read the article

• SilverDiagram new learn section

  - by Braulio Díez Botella

  We have created a new section on our site: SilverDiagram Learn In this site you will find: Links to our codeplex extensions / samples. How to… videos, right now: How to build the codeplex samples. How to create custom shapes. Link to articles / post / documentation. I hope this will make easier to let you get started with SilverDiagram SDK. More videos and samples coming soon…

  Read the article

• Connecting Ubuntu home server to internet via laptop

  - by Gray-Wolfe

  I recently got a spare desktop computer from a relative to play around with and since I've been using Ubuntu for a few years I decided to install Ubuntu Server 12.04 to play around with and learn more. However it doesn't have a wireless card, the wireless adapter had a shipping error and will be awhile, and plugging it into the router is not an option. So I figured I could give it access to the wifi from my laptop(which I switch between Windows and Ubuntu) so I could at least get some things started and set up while I'm waiting for the adapter. However the few guides I can find to do that require a GUI, something lacking on the server version. Could someone tell me how to set this up via the terminal? I would appreciate it.

  Read the article

• LAMP server has gone down a few times. Ideas for server optimization?

  - by MattB

  Hi all, Our production web server has gone down a few times over the course of the last half year. In the end, we've needed to contact the web host and have them restart as I'm unable to even SSH in. This appears to only affect the web server and not the MySQL database server which is separate. When it affects the web server, all hosted websites time out. I'd like to examine web server optimization/corrections to get to the root of this issue. Any recommendations on how to proceed with that? I'm sure log files would play a role. I'm able to find my way around a Linux-based server and make needed changes, but would be interested in any tips I may not have thought of yet. It may be best for us to speak with an outside consultant as another option. Thanks.

  Read the article

• win2003 server problem

  - by Tavo

  I used to have a server with win2000 OS. Yesteday I updated it to win2003 server R2 service pack 2. My problem now is that in a particular moment nobody can access the server. All of the shared resource of the server are unavailable. The only solution is to restart the server although the server is running fine. I don't think that is a connection problem of the LAN, because with the win2000 this problem didn't happend. The PC is connected to the same switch and the PC have the same exact hardware.

  Read the article

• Learn SSIS in London 12-14 Sep 2012!

  - by andyleonard

  My friends at TechniTrain , the students, and I had a blast during the March 2012 London delivery of From Zero To SSIS ! We have decided to do it again in September 2012 with my new Learning SSIS 2012 3-day course ! Please find a course outline here . It is difficult to list everything I cover in the course, but the outline hits the high spots. This material grew out of my experiences serving as a consultant on short-term engagements and as a manager (and enterprise ETL architect) for a team of forty...(read more)

  Read the article

• BCM4313 Wireless on Ubuntu Server 12.04

  - by KJ Tsanaktsidis

  I'm trying to run an old netbook with Broadcom BCM4313 wireless as a print server with Ubuntu Server 12.04. Setting up the wireless without the GUI, however, is proving problematic. I do think however I've narrowed down the problem. I've tried both the wl driver (from bcmwl-kernel-source) as well as the (included) brcmsmac driver. With both of them, when I issue the command iwlist wlan0 scanning (eth1 for wl), I only see neighbouring networks- not my own. I believe this might be because my networks are n-only, but my neighbouring networks are mixed mode (I suspect this because the output of iwlist wlan0 scanning shows "Bit Rates" only as high as 54 Mb/s). Any ideas how to go about getting this thing to connect?

  Read the article

• Can Oracle XE and Microsoft SQL Server 2005 run on the same server in a production environment?

  - by Michael Rosario

  Hello world. Can Oracle XE and Microsoft SQL Server 2005 run on the same server in a production environment? From an IT professional position, why would I not allow Oracle XE and MSSQL2005 to run on the same server?

  Read the article

• Mouse stopped responding after installing Ubuntu Server

  - by Danijar

  It was 2 operating systems on my machine, Windows 7 and Ubuntu Desktop 12.04, both 64bit version. All works well, firstly I installed Win, then the Desktop version of Ubuntu, lasts's GRUB rewrites windows's boot and of course added it as a variant to load. Yesterday I wish to play with Ubuntu Server 12.04, and install it as a third operating system. During the installation Server's GRUB seems to rewrite that which installed earlier (background color became black, was purple). Firstly, newly installed GRUB generates me overmuch load options for Ubuntu Desktop, by two for each kernel version (normal and recovery modes). OK, it's bearable, but most thing, that the mouse on this machine is totally stops responding, regardless which operating system I choose to load. Hope somebody help me. Thanks in advance!

  Read the article

• Learn How to Make Money Writing Articles Guide

  Learn how to make fast and easy money. This article will teach you how to make money writing articles.

  Read the article

• SEO Courses - What Will You Learn?

  Today very important for every website owner is to make sure that his or her website is properly optimized, because that is a very good way to attract more visitors and they will consider your website relevant, because it will allow it to appear higher in the search results of the search engines. One of the best ways to learn how to do make SEO on your website is to attend SEO courses.

  Read the article

• What OpenGL version(s) to learn and/or use?

  - by zuko

  So, I'm new to OpenGL... I have general knowledge of game programming but little practical experience. I've been looking into various articles and books and trying to dive into OpenGL, but I've found the various versions and old vs new way of doing things confusing. I guess my first questions is does anyone know some figures about percentages of gamers that can run each version of OpenGL. What's the market share like? 2.x, 3.x, 4.x... I looked into the requirements for Half Life 2 since I know Valve updated it with OpenGL to run on Mac and I know they usually try to hit a very wide user-base, and they say a minimum of GeForce 8 Series. I looked at the 8800 GT on Nvidia's website and it listed support for OpenGL 2.1. Which, maybe I'm wrong, sounds ancient to me since there's already 4.x. I looked up a driver for 8800GT and it says it supports 4.2! A bit of a discrepancy there, lol. I've also read things like XP only supports up to a certain version, or OS X only supports 3.2, or all kinds of other things. Overall, I'm just confused as to how much support there is for various versions and what version to learn/use. I'm also looking for learning resources. My search results thus far have pointed me to the OpenGL SuperBible. The 4th edition has great reviews on Amazon, but it teaches 2.1. The 5th edition teaches 3.3 and there are a couple things in the reviews that mention the 4th edition is better and that the 5th edition doesn't properly teach the new features or something? Basically, even within learning material I'm seeing discrepancies and I just don't even know where to start. From what I understand, 3.x started a whole new way of doing things and I've read from various articles and reviews that you want to "stay away from deprecated features like glBegin(), glEnd()" yet a lot of books and tutorials I've seen use that method. I've seen people saying that, basically, the new way of doing stuff is more complicated yet the old way is bad . Just a side note, personally, I know I still have a lot to learn beforehand, but I'm interested in tessellation; so I guess that factors into it as well, because, as far as I understand that's only in 4.x? [just btw, my desktop supports 4.2]

  Read the article

• Remote Desktop Problem on Windows Server 2008 R2

  - by lukiffer

  Revised this question to be more concise, consolidating several revisions. Symptoms: From a domain-member Windows 7 Client: Domain credentials to a domain controller = success Domain credentials to a member server (by hostname or FQDN) = success Domain credentials to a member server (by IP) = fail Local credentials to a member server (by either) = success From a non-domain-member Windows 7 Client: Domain credentials to a domain controller = success Domain credentials to a member server = fail Local credentials to a member server = success (Identical behavior from a Mac RDC 2.1 client) Server Configuration Details: Windows 2008 R2 Datacenter w/ SP1 The domain in question is a subdomain of a Windows 2008 domain (forest root). Root has DCs in both Site A and Site B, subdomain only has DCs in Site B. RDP is operating normally on all root member-servers and DCs. No remote desktop settings are defined by GPOs. Network level authentication is enabled; all clients are compatible and the certificate exchange/SSL handshake completes successfully. Not catching any errors in netlogon log.

  Read the article

• Hosting server application for global SME

  - by BBe

  We are planning to set up a complete ERP and CRM system for a medium-sized global company, that might turn into a essential tool for all locations once deployed. For now these locations include USA, Germany, China and Indonesia, but the list is growing quickly. My question is, where it is best to physically locate the server to ensure the access times are optimal from all (future) locations? On my mind, I am dealing with multiple connected servers (a cloud?), where each of our users is served by the physically closest server. Being in a very competitive field we would also like to rule out, that any data is stored in mainland China... Thanks for any advice and pointers!

  Read the article

• Running 32 bit SQL Server 2005 on 64 bit Windows Server?

  - by TooFat

  If I have a 32 bit version of SQL Server 2005 running on a 64 bit Windows Server does the max amount of memory avail. the SQL Server process increase from 2gb to 4gb. In reading this blog entry by Mark Russinovich in which he states that "All Microsoft server products and data intensive executables in Windows are marked with the large address space awareness flag" and "Because the address space on 64-bit Windows is much larger than 4GB, something I’ll describe shortly, Windows can give 32-bit processes the maximum 4GB that they can address and use the rest for the operating system’s virtual memory." which leads me to believe that the answer is "yes" but I not totally confident.

  Read the article

• How to prevent a database from being restored?

  - by André

  Is there a way to prevent a database from being restored with a DDL trigger or something? The background is that I would like to prevent restoring a database on a test server by a colleague. So far I had a look a DDL trigger but didn't find the right event to react on the restore action.

  Read the article

• Can't copy file (I/O error) Ubuntu Server

  - by QxQ

  I'm running Ubuntu Server 12.04, and basically found out that a couple of files aren't behaving like they should. The file name is r.-1.-1.mca, and I've tried using this terminal command sudo cp r.-1.-1.mca ../ The hard drive is working/thinking for a while, then spits this back out: cp: reading `r.-1.-1.mca': Input/output error cp: failed to extend `../r.-1.-1.mca': Input/output error I have another file behaving like this. My guess is that these files are corrupt, so I tried running the server in recovery mode and it told me to check the file system. However, it didn't come up with any errors. Is there a way to repair these files so I can use them normally again?

  Read the article

• Moving Data From Excel to SQL Server - 10 Steps to Follow

  SQL Server Integration Services provide a versatile way of reading Excel files into SQL Server. A task like this illustrates the advantages of the graphical approach of SSIS. Andy Brown explains. Want to work faster with SQL Server?If you want to work faster try out the SQL Toolbelt. "The SQL Toolbelt provides tools that database developers as well as DBAs should not live without." William Van Orden. Download the SQL Toolbelt here.

  Read the article

• How to configure my web server for public and development service

  - by Steve

  I have one and only one web server, which runs Windows Server 2008 and wamp. Now I would like to setup SVN on the server so I can program the trunk version of the website. Every time I branch a version and put it to public. While developing on the trunk version, I also want to be able to test it. The web server has 5 IPs so I can use one IP for public website(the branch) and another IP for trunk development test. I believe one wamp server can only handle one 80 port request thus can only handle one website. How can I configure the server so it can handle one IP request and direct to my branch and handle another IP request and direct to my trunk?

  Read the article

• Eager to Learn more about MySQL?(Week 40)

  - by rituchhibber

  Are you a SQL programmer eager to know more?Oracle University is pleased to announce the availability of a new course in Training on Demand format : MySQL Performance Tuning.Why wait to get the training you need? Learn Oracle from Oracle today. Check out the demo to see how it works.Take a look at the new Training on Demand  MySQL Certification Packages.Please note: your OPN discount is applied to the standard price shown on the website.For more information, assistance and bookings contact your local Oracle University Service Desk.

  Read the article

• Connecting via url to a server that is on the same network as me

  - by Axehead

  Good day, I'm having problems with the ftp server I've just set up. I've already managed to configure my modem and wireless router to open up port 21 and setup ftp in my server. But It seems that when I try to connect to it when I'm in the same network as the server via URL, (ftp://mydomain.com) it redirects me to the modem's web interface. But then when I try to connect to it outside the network using a different internet connection. It succeeds. It also succeeds when I'm in the same network and I go to ftp://192.168.., the server's local IP. Am I supposed to adjust something in the modem or router? Or is this a different problem altogether? BTW I'm using Windows Server 2008 r2 as my server's OS and using IIS for ftp.

  Read the article

• Oracle OpenWorld 2012?????WebLogic Server???3??????

  - by ???02

  ???????2012?9?30???10?4?(????)???4???????????????????????????Oracle OpenWorld 2012???????????????????????WebLogic Server????????????????????????????????????(Fusion Middleware?????????????????????????????)?????(???) ??????????????WebLogic Server?????? ??????Fusion Middleware??????????????????????????????????? ???????????OpenWorld??????WebLogic Server????????????????????????????(HTML5)???Oracle Database??????????3???????????????????????????? OpenWorld 2012?????????CEO????·??????????????·?????Oracle Cloud??????????SaaS?PaaS????IaaS???????????????? ??????????????????/?????????????????????????????????WebLogic Server????????????????????????????????????????·??????????????????????????????Oracle Exalogic Elastic Cloud?????????????????????????????????????????·???????????????????????? ???????????????·??????????·???????????????????????????????????????WebLogic Server?Oracle Enterprise Manager??????????????????????? ?????????????????????????????????·???????????????????????????????????????(???)????????????????????·???????????????????????????? ??????????·????????????????????????????????????????????????????????????????????Java EE????????????????????????·???????Oracle E-Business Suite????????????·???????????????????????????????????????????????????????????????????????? ??????????????????????????????????·????????????????????????????????????????????????????????????????????????????????????? ?WebLogic Server?Oracle Enterprise Manager?????????Exalogic?????????????????????????·????????????????????????????????????????????????????????????????????????????????????????????????????????OpenWorld?????????Exalogic???????????????????????/?????????????????????????????WebLogic Server?????????????????????????????????????(???) ?????????????????OpenWorld 2012???Java???????Oracle Developer Cloud Service???????????????·?????????????????????????·???????·??????????????????????????????·????·????????????????????????????Java??????????????????????????????????????????????????????????????????????????WebLogic Server????????????????? WebSockets?SSE???????Java EE???????? ????????Java??????????Java EE??????????????Java EE 7???????????????????????7???Java EE??????????????????·?????????????????????????????????????????????HTML5???????????????????????? ??????????Java EE??????????????WebLogic Server???????????12.1.2?????Java EE 7??????????Web???????????????????WebSockets???HTTP?????????????Server Sent Events(SSE)????????????????????????????OpenWorld 2012?????????WebSockets?SSE???????????????????????????Web???????????????????????????????????????????????????????????????? ???WebLogic Server?????????2013?????????????????Java EE 7??????????????????????Java?????????????????????????????????????WebLogic Server?????????????????????? ???WebLogic Server?????????????????Oracle TopLink DataService?????????????????????????????XML?JSON??????????????????????Java??????????????·????????????????????????????????????????????????????·????????????????????????? Oracle Database??????????? WebLogic Server???????????·??????????????????1???Oracle Database????????????????OpenWorld 2012?????????Oracle Database????????????????????? WebLogic Server????Oracle Real Application Clusters(RAC)?????????????????????????????????????Active GridLink for RAC??????????????????????????????????????????????????????????·?????????????Oracle RAC?????????????????·??????????????????????????????????????Oracle RAC????????????? OpenWorld 2012?????Active GridLink for RAC???????????????????????????????Application Continuity??????????????? ?????????????·???????????????Oracle RAC?????????????????????????????????????????????????????????????????Application Continuity?????JDBC???????????????????????????Oracle RAC??????????????????????????????????????????Oracle Coherence?????????????????????????????????·????????????????(???) ?????????????????·???????????????Java????????????WebLogic Server???????????????? ????????????????????????????????????????????/???????????????????WebLogic Server?????????????????????????? ??????·???????????????·????????????Java EE?????????????OpenWorld 2012????????WebLogic Server?????????????????????????????????????????????????????????????Java EE??????????????????????WebLogic Server????????????????????????????Java EE?????????????Java EE???????????????????????????(???) ????????·????????????????????????????????????Java EE????WebLogic Server?????????????????????????????????

  Read the article

< Previous Page | 220 221 222 223 224 225 226 227 228 229 230 231  | Next Page >