Skip to content
December 4, 2023
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Event Free Live Training Virtual Symposium DPD banglore
  • Free Courses
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
    • Browse Events
    • Suggest Topics
  • Videos
    • SSG Videos Lobby
    • Premium Content (SQLMaestros)
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes by Amit Bansal (AB)
  • About Us
    • Subscribe To Our Newsletter
    • Social Channels
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Tag: sql server 2008

SQL Server

Identify TCP Port Number of a SQL Instance

October 31, 2014November 3, 2014 - by Arsalan Khan - Leave a Comment

There are a lot of instances when you are asked to identify TCP port number for a SQL instance unless you use default port (1433) across the board. There are several ways to …

Identify TCP Port Number of a SQL Instance Read More
SQL Server

SQL Server SNAPSHOT Isolation mode in FILESTREAM database on SQL Server 2008

December 2, 2013September 11, 2014 - by Kanchan Bhattacharyya - Leave a Comment

Dear Friends, Last week we have had a situation where one of our colleague(s) was trying to change database isolation to SQL Server SNAPSHOT Isolation in one of the SQL Server …

SQL Server SNAPSHOT Isolation mode in FILESTREAM database on SQL Server 2008 Read More
SQL Server

LRU-K algorithm – Quick look

October 2, 2013September 27, 2014 - by Kanchan Bhattacharyya - Leave a Comment

Dear Friends, To start with; we can use a data or index page only when they exist in memory. For improved performance it is very important to keep alive the supply …

LRU-K algorithm – Quick look Read More
SQL Server

SQL Server: Why the size of the backup file changes?

November 14, 2011July 5, 2014 - by admin - Leave a Comment

Hi Friends, Have you ever noticed, while taking a compressed backup the file which gets created initially has a different size than the final file size when the backup completes. To …

SQL Server: Why the size of the backup file changes? Read More
SQL Server

SQL Server DB Mail Account Creation Failed – A Bug

August 17, 2011November 14, 2014 - by admin - 3 Comments.

One fine day i was configuring DB Mail on one of my server and while configuring Mail Account i encountered the following error. This Bug\Problem is applicable to SQLServer 2008 SP1, …

SQL Server DB Mail Account Creation Failed – A Bug Read More
SQL Server

Full text search Introduction and its integrated in SQL Server 2008

May 6, 2011December 18, 2014 - by Arjit Malviya - Leave a Comment

Hello Everyone, You must have heard about the SQL Server “Full Text Search” functionality. Basically it provides the functionality for applications and users to issue full-text queries against character-based data in …

Full text search Introduction and its integrated in SQL Server 2008 Read More
SQL Server

New Date and Time Data Types in SQL Server 2008

April 20, 2011December 18, 2014 - by Arjit Malviya - Leave a Comment

SQL Server 2008 introduces four new DATETIME data types as follows: DATE: – In Previous versions of SQL Server, we had to use the DATETIME or SMALLDATETIME data types even though …

New Date and Time Data Types in SQL Server 2008 Read More

Posts navigation

Previous 1 2

Looking for Premium SQL Content?
Check out advanced SQL tutorials
on SQLMaestros


Subscribe to SQLServerGeeks

Free Live Event


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Virtual Symposium

Copyright © 2022 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.