Search Results

Search found 1137 results on 46 pages for 'upk tip'.

Page 15/46 | < Previous Page | 11 12 13 14 15 16 17 18 19 20 21 22  | Next Page >

• When SQL Server Nonclustered Indexes Are Faster Than Clustered Indexes

  SQL Server Clustered indexes can have enormous implications for performance of operations on a table. But are there times when a SQL Server non-clustered index would perform better than a clustered index for the same operation? Are there any trade-offs to consider? Check out this tip to learn more. Deployment Manager 2 is now…

  Read the article

• my site works with www.my site.com but not like this http://www.my site.com

  - by toocool

  this is the site that I am going to develop: http://www.juve-news.com/ it works like this but it doesnt when I try to open it without the www prefix. it give me 400 bad request! I have used other web host before now I am trying a new one and I have to add some dns entries like in the picture here:…

  Read the article

• Built-In SQL Server Agent Performance Reports in SQL Server 2005

  SQL Server 2005 includes a number of built-in reports to assist you in troubleshooting and measuring performance. In this tip I will cover the Built in SQL Server Performance Reports related to SQL Server Agent within SQL Server 2005.

  Read the article

• A Better Way to Retrieve the ID of the Last Inserted Record

  An update to a previous tip on retrieving the ID of the last inserted record, this version uses less code and avoids a search of the jobs table.

  Read the article

• Kalculate = math + fun

  - by Devin A. Rychetnik

  Kalculate is a you vs. the Internet style game for math lovers. The rules are simple: answer as many math problems as you can in 90 seconds. At the end of each round, Kalculate will tally up all the scores and show you where you ranked relative to others currently playing.Tip: answering 3…

  Read the article

• Retrieving Table Size in SQL Server

  Use this handy tip to determine the size of your SQL Server tables, which can be very useful for estimating the size and growth of a database over time.

  Read the article

• Retrieving Table Size in SQL Server

  Use this handy tip to determine the size of your SQL Server tables, which can be very useful for estimating the size and growth of a database over time.

  Read the article

• Database recovery model change notification report for SQL Server

  The database recovery model plays a crucial role for the recovery of a database. With several DBAs having access to a SQL Server instance there are bound to be changes that are not communicated. In this tip we cover a monitoring solution we deployed at our company to alert the DBAs if a…

  Read the article

• SEO - Guru's Dark Secrets Or a Necessary Skill That Should and Can Be Learned?

  Search Engine Optimization or SEO always sounded very intimidating to me, so I ignored it... yes I just decided it was some more of the jargon used by marketers trying to sell me something. It took me a while picking up a tip here and a hint there to realize that SEO had something to do…

  Read the article

• SQL SERVER SELECT TOP Shortcut in SQL Server Management Studio (SSMS)

  This is tool is pretty old, yet always comes as a handy tip. I had a great trip at TechEd in India. And, during one of my presentations, I was asked if there are any shortcuts to SELECT only TOP 100 records from SSMS.I immediately told him that if he explores the table in SSMS,…

  Read the article

• 3 tips for SQL Azure connection perfection

  - by Richard Mitchell

  One of my main annoyances when dealing with SQL Azure is of course the occasional connection problems that communicating to a cloud database entails. If you're used to programming against a locally hosted SQL Server box this can be quite a change and annoying like you wouldn't…

  Read the article

• SQL Server stored procedure to generate random passwords

  SQL Server is used to support many applications and one such feature of most applications is the storage of passwords. Sometimes there is a need to reset a password using a temporary password or generate a random password for a new user. In this tip I cover a simple stored…

  Read the article

• Adding Custom Reports to SQL Server Management Studio

  In this tip, Koen Verbeeck explores how to apply business intelligence solutions to administrative tasks, specifically creating custom reports and adding them to SQL Server Management Studio. An accidental DBA? Try SQL MonitorUse the 30-day full product…

  Read the article

• Quick SEO Tips - Keyword Placement

  Another quick SEO tip aimed to help webmasters gain that additional advantage over the competition. In this article we take a look at Keyword Placement and how this can give your site the extra lift required in today's hard markets.

  Read the article

• Open-Source Software Shortcut, Excluding Directories From Grep

  Tip of the Trade: Want to use Grep without including some directories? Here's a simple, yet efficient way, for the open-source software to find what you're looking for.

  Read the article

• Hiding System Objects in Object Explorer in SQL Server Management Studio

  While looking through the new features and improvements in SQL Server Management Studio (SSMS) we found a potentially interesting one to Hide System Objects in Object Explorer in SQL Server Management Studio. In this tip we will take a look at how to Hide System Objects…

  Read the article

• Annotating PDFs With the Open-Source Software Package Okular

  Tip of the Trade: If you've ever felt the need to scribble notes on your PDFs without bringing dead trees into the equation, consider the open-source software, Okular, a KDE document reader that can read multiple document formats and allows the user to annotate files as…

  Read the article

• Creating a Reporting Services Histogram Chart for Statistical Distribution Analysis

  Typically transactional data is quite detailed and analyzing an entire dataset on a graph is not feasible. Generally such data is analyzed using some form of aggregation or frequency distribution. One of the specialized charts generally used in Reporting Services for…

  Read the article

• From the Tips Box: Location-based To-Do Reminders, DIY Floppy Drive Music, and Easy Access to Product Manuals

  - by Jason Fitzpatrick

  Once a week we round up some great tips from the HTG tip box and share them with you; this week we’re looking at location based to-do reminders for Android phones, how to make your own floppy drive symphony, and an easy way to enjoy anywhere access to your manuals…

  Read the article

• Simple Steps to Prepare Mirror Database for Mirroring in SQL Server

  To prepare a database for mirroring, you need to perform the following steps: Script the restore of the latest full database backup, script the restore of every transaction log backup that has been made after that full database backup, copy the full database…

  Read the article

• Trending Buffer Pool Performance Using DMV sys.dm_os_performance_counters

  I'd seen you posted a tip on capturing SQL based PerfMon counters using sys.dm_os_performance_counters. What queries can I run against those stored results that would allow me to examine memory usage on my SQL instance? Join SQL Backup’s…

  Read the article

• Setting Up Tunneling With a VirtualBox Guest Machine

  Tip of the Trade: VirtualBox makes it easy to set up and run virtual machines on your own desktop. It is not perfect, however, and by default, the guest VM is invisible to the host or any other machines on the network. Here's an easy way to relay…

  Read the article

• Migrate to Natively Compiled SQL Server Stored Procedures for Hekaton

  In order to take full advantage of the In-Memory OLTP options in SQL Server 2014, you should migrate standard stored procedures that references Memory-Optimized tables to natively compiled ones. In this tip we will see how to achieve this goal. …

  Read the article

• Marketing Tips: How to Transfer Big Video Files

  We look at ways to store and transfer large files over the Internet, affordable stock photos, and a tip from the OutBack restaurant that you can easily adapt to your small business marketing strategy.

  Read the article

• Marketing Tips: How to Transfer Big Video Files

  We look at ways to store and transfer large files over the Internet, affordable stock photos, and a tip from the OutBack restaurant that you can easily adapt to your small business marketing strategy.

  Read the article

< Previous Page | 11 12 13 14 15 16 17 18 19 20 21 22  | Next Page >