Search Results

Search found 27530 results on 1102 pages for 'sql truncate'.

Page 794/1102 | < Previous Page | 790 791 792 793 794 795 796 797 798 799 800 801  | Next Page >

• Don’t just P2V that server for Testing!

  - by Jonathan Kehayias

  If you use virtualization in your company, at some point in time you might be tempted to perform a Physical-To-Virtual conversion, also known as P2V.  The ability to create a complete working copy of a physical server as a virtual machine is really useful for migrating to a virtualized datacenter, but it can also wreak havoc in your…

  Read the article

• New DMV… not yet

  - by Michael Zilberstein

  Downloaded and installed new toy: And while reading BOL, stumbled upon new extremely useful DMV: sys.dm_exec_query_profiles . This DMV enables DBA to monitor query progress while it is being executed. Counters in the DMV are per operation per thread. So we’ll be able to monitor in real time which thread (even for parallel processing)…

  Read the article

• SQLBits VI session submission - Today is your last day

  - by simonsabin

  We will be deciding on the sessions tomorrow (Tuesday 8th March) so make sure you get your session in for SQLBits quick. Don't forget we are focussing on performance an scalability so make sure your session covers one or both of these. To submit your session Step 1 - Complete your Speaker Profile Step 2 - Submit My Sessions

  Read the article

• SQLBits VI session submission - Today is your last day

  - by simonsabin

  We will be deciding on the sessions tomorrow (Tuesday 8th March) so make sure you get your session in for SQLBits quick. Don't forget we are focussing on performance an scalability so make sure your session covers one or both of these. To submit your session Step 1 - Complete your Speaker Profile Step 2 - Submit My Sessions

  Read the article

• Update RDS db via mysqlbinlog: "you need (at least one of) the SUPER privilege(s)"

  - by timoxley

  We are moving a production site to EC2/RDS Followed these instructions: http://geehwan.posterous.com/moving-a-production-mysql-database-to-amazon I have set up row-based binary logging on the production server did a: mysqldump --single-transaction --master-data=2 -C -q -u root -p backup.sql then imported to RDS instance.…

  Read the article

• The ethics of aggregating other peoples' content

  - by AaronBertrand

  Content theft Most of the recent - what I'll call - "discussions" about content aggregators have revolved around content theft. I'm not going to flip-flop on that topic: when you use someone else's work, you ask first, and if given the okay, you cite it. You can't take my blog article and post it on your site, implying that it is…

  Read the article

• Performance Gains using Indexed Views and Computed Columns

  - by NeilHambly

  Hello This is a quick follow-up blog to the Presention I gave last night @ the London UG Meeting ( 17th March 2010 ) It was a great evening and we had a big full house (over 120 Registered for this event), due to time constraints we had I was unable to spend enough time on this topic to really give it justice or…

  Read the article

• automysqlbackup not working weirdly on shared host

  - by KPL

  I'm on HostGator and I have not-root-level SSH access. I manually setup automysqlbackup in a /home/user/automysqlbackup folder. Created a file called runbackup in the same folder, chmod +x'ed it. The content : /home/user/automysqlbackup/automysqlbackup /home/user/automysqlbackup/myserver.conf Now, when I run ./runbackup…

  Read the article

• Working with Spatial Data Part IV - Developing a Geospatial Dashboard (GIS)

  This article leverages the examples and concepts explained in the third part of this spatial data series which develops a "BI-Satellite" app ( Reporting spatial data with SSRS 2008 R2 and Reports Builder 3.0 Part-III ... [Read Full Article]

  Read the article

• Kimball University: Three ETL Compromises to Avoid

  Why neglecting slowly changing dimensions, failing to capture metadata and overlooking scope creep can be the undoing of a dimensional data warehousing initiative.

  Read the article

• What Should PASS Be?

  - by andyleonard

  Introduction As he does so well, Andy Warren ( Blog | @sqlAndy ) has issued a challenge to the community: What Should PASS Be? I'm sure lots of people have responded already, but I've been struck by two: Grant Fritchey's ( Blog | @GFritchey ) What Should PASS Be? and Robert Matthew Cook's ( Blog | @sqlmashup ) [blog] What…

  Read the article

• My old Conchango blog posts are currently not accessible

  - by jamiet

  Some of you reading this may be aware that I used to blog at http://blogs.conchango.com/jamiethomson. That URL later changed to http://consultingblogs.emc.com/jamiethomson after Conchango (my employer) got taken over by EMC. In my last post on that site: I stated that I had 676 blog posts on that site. …

  Read the article

• Updated slide decks from SSMS presentation at SNESSUG

  - by AaronBertrand

  Tonight I spoke at the SNESSUG user group meeting in Warwick, RI. You can download the slide deck here (this is a 3.5 MB PDF with presenter notes): http://sqlblog.com/files/folders/23423/download.aspx If you attended the talk, please feel free to provide feedback at speakerrate.com:…

  Read the article

• We've hit 400 registrations for SQLBits VI

  - by simonsabin

  After a mad rush for registrations to SQLBits VI we ahve now hit 400 registrations. We still have places yet but don't expect then to be available long. At the current rate you've got 7 days until we will have filled up. So get registering, also if you can't make it…

  Read the article

• We've hit 400 registrations for SQLBits VI

  - by simonsabin

  After a mad rush for registrations to SQLBits VI we ahve now hit 400 registrations. We still have places yet but don't expect then to be available long. At the current rate you've got 7 days until we will have filled up. So get registering, also if you can't make it…

  Read the article

• Can I delete libc-bin?

  - by Balazs Szikszay

  Question is simple, I need to know because I cant upgrade/install anything, because it always says I have to uninstall/delete it to continue. It also says dont do it, if I dont know what I am doing. EDIT: szikszay@szikszay-Latitude-E5530-non-vPro:~$ sudo apt-get upgrade …

  Read the article

• SyncToBlog #10 Lots of Azure and Cloud Links including MIX10 videos

  - by Eric Nelson

  Just getting a few interesting cloud links “down on paper”. I last did one of these on Azure in Feb 20010. Cloud Links: Article on Debugging in the Cloud http://code.msdn.microsoft.com/azurescale  A sample app that demonstrates monitoring and automatically…

  Read the article

• Intel Xeon 5600 (Westmere-EP) and AMD Magny-Cours Performance Update

  - by jchang

  HP has just released TPC-C and TPC-E results for the ProLiant DL380G7 with 2 Xeon 5680 3.33GHz 6-core processor, allowing a direct comparison with their DL385G& with 2 Opteron 6176 2.3GHz 12-core processors. Last month I complained about the lack of performance…

  Read the article

• .Net to Oracle Connectivity using ODBC .NET

  - by SAMIR BHOGAYTA

  You can use the new ODBC .NET Data Provider that works with the ODBC Oracle7.x driver or higher. You need to have MDAC 2.6 or later installed and then download ODBC .NET from the MS Web Site…

  Read the article

• Good News for Women in Technology - Barbie Has Joined the IT Scene

  - by KKline

  Notice the bluetooth ear piece fashion faux pas? Yes, she's truly a geek. I'm happy to report that Barbie is now a cognizeti, a digerati, ... yes even an IT Professional! This year's new…

  Read the article

• Simple Criminal Minds

  - by andyleonard

  My favorite mother-in-law hooked my bride on the television series Criminal Minds during her last visit. I started watching the show as well, and sort of followed along. I was ok with…

  Read the article

• CodePlex Daily Summary for Saturday, May 12, 2012

  CodePlex Daily Summary for Saturday, May 12, 2012Popular ReleasesKanboxAPI: KanboxAPI beta: ????? Token Info List DownloadMedia Companion: Media Companion 3.502b: It has been a slow…

  Read the article

• How can you know what is w3wp.exe doing? (or how to diagnose a performance problem)

  - by Daniel Magliola

  I'm having a performance problem in a site we've made, and I'm not exactly sure how to start diagnosing it. The short description is: We have a very small site…

  Read the article

• Curious about IObservable? Here’s a quick example to get you started!

  - by Roman Schindlauer

  Have you heard about IObservable/IObserver support in Microsoft StreamInsight 1.1? Then you probably want to try it out. If this is your first incursion into…

  Read the article

• Exploring the Excel Services REST API

  - by jamiet

  Over the last few years Analysis Services guru Chris Webb and I have been on something of a crusade to enable better access to data that is locked up in…

  Read the article

< Previous Page | 790 791 792 793 794 795 796 797 798 799 800 801  | Next Page >