About the SQLServerCentral Group
Have something to say?
Join LinkedIn for free to participate in the conversation. When you join, you can comment and post your own discussions.
Join LinkedIn-
#0136 - SQL Server – SSMS – Slow load times - Improving launch... beyondrelational.com
As you know, I recently completed a 10-part tutorial series on the...
-
#0146 – SQL Server – Exception handling change - DECLARE can now... beyondrelational.com
It is very important to keep revisiting one’s code – especially, when...
-
Extensions for Primary/Secondary Data and Log Files – Are MDF/NDF and... beyondrelational.com
Ever since anyone starts learning Microsoft SQL Server, a...
-
The SQL Server 2012 Upgrade Technical Guide is out! Woohoo! download.microsoft.com
-
SQL VIEW Basics simple-talk.com
SQL Views are essential for the database developer. However, it is...
-
Create CNN-style Map in Reporting Services sqlservercentral.com
Map is one of the exciting new features introduced in SQL Server 2008...
-
10 tips on converting MS SQL queries to MySQL sqlservercentral.com
When migrating databases from Microsoft SQL Server to MySQL, it is...
-
SQL Server - Statistics object name _WA_Sys_00000003_1EF99443. Let us...
Hi Friends, A light blog for the weekend. What is the logic behind...
SQL Server - Statistics object name _WA_Sys_00000003_1EF99443. Let us... -
SQL Server Central Users Survey 2012 surveymk.com
We want to make sure we're covering the things that are relevant to...
-
What, when and who? Auditing 101 - Part 3 sqlservercentral.com
In the previous two articles of this series, we looked at Change...
-
Update to Adaptive Index Defrag script. If you use it, time to update! blogs.msdn.com
Blog of the Portuguese SQL Server PFE Team, providing insight and...
-
Registration Page for Scaling Big Data Bonus Session dbshards.com
Need to scale your data tier? The foundation of every application is...
-
Maintaining SQL Server default trace historical events for analysis... mssqltips.com
I often see questions online where someone wants to find out who...
-
Managing Database Data Usage With Custom Space Alerts sqlservercentral.com
As DBAs, we are often placed in situations where we have to manage...
-
SQL Server Central Webinar Series #19: Proactive Data Growth... gotomeeting.com
In this webinar Steve Jones, SQL Server MVP will be your host to...
-
Atlassian Blogs blogs.atlassian.com
We talk a lot about continuous integration here on the Atlassian Dev...
-
The PoSh DBA: Grown-Up PowerShell Functions simple-talk.com
Laerte goes step-by-step through the process of tidying up and making...
-
SSIS FTP Task - Receive Files from FTP Site sqlservercentral.com
Yes, there are many clients available in the market for FTP needs and...
Most Popular Discussions
Amit
Hi Friends,
just a quick note on installing SQL 32 bit on 64 bit OS.
Hope you like it! Here is the direct link to the blog:
http:// ...
Installing SQL Server 32 bit on 64 bit Operating System sqlservergeeks.com
Amit Bansal(Member since: 3/12/2011 4:59:54 PM) Follow Amit at Twitter @A_Bansal : Amit Bansal is the CTO of eDominer Systems & Peopleware India. He is a consultant, trainer, writer, speaker & evangelist on SQL Server &...
Luiz
Site brasileiro com a finalidade de postar dicas e cases de SQL Server em português e ajudar os analistas que procuram querys de ...
SQL Dicas! sqldicas.com.br
Muito bem vindos ao SQL Dicas! Aqui você vai encontrar dicas, cases e scripts de situações que vivenciamos no dia a dia. Cada vez que me deparar com uma situação interessante, curiosa, complexa ou até situações mais simples vou...
Nakul
CAST v/s CONVERT – Is there a difference as far as SQL Server is... beyondrelational.com
Data type conversion has been one of the most used features of any programming language. Microsoft SQL Server users are familiar with the two functions: CAST() and CONVERT() and use them regularly, and more specifically,...
Nelson
Index Fragmentation - Understanding Fragmentation
Index Fragmentation - Understanding Fragmentation
Practical SQL DBA practicalsqldba.com
When I had a discussion with couple of my friends about index fragmentation, I realized that they have different understanding about index fragmentation. In this post I will try my level best to explain different types of...
Amit
Hi Friends,
Here is a simple explanation of cost threshold of parallelism server level property in SQL Server.
Hope you like it!
Here ...
SQL Server - Cost Threshold of Parallelism sqlservergeeks.com
Hi Friends, What triggers me to write this blog today is that in one of my recent consulting...
Maintaining SQL Server default trace historical events for analysis and reporting mssqltips.com
I often see questions online where someone wants to find out who started a trace, when tempdb last had an autogrow event, or when the last full backup for master occurred. Usually we have to tell them that they *might* be able...
Satnam
Using DML Triggers to Capture Multiple Events sqlservergeeks.com
AS DBAs we often need to develop DML triggers to capture multiple entries which are either...
Angad
Derived Tables or CTE ?
I had a scenario, in which i used the CTE to update a column using GROUP BY clause and other joining, but i was then told to use it as ...
Kalyan
Lynea
I'm attempting to create a table based on two tables, but I keep getting a mysterious syntax error near the keyword 'AS'...
The basic syntax is:
CREATE TABLE new_table
AS (SELECT column_1, column2, ... column_n
FROM old_table_1, old_table_2, ...
Work around for calculating age using the SQL Server DateDiff function mssqltips.com
Have you ever wanted to compute age, but the results from the DATEDIFF function seemed to be wrong some of the time? In this tip we cover why the DATEDIFF function does not always reliably compute age?
Rahul
Hi SQL Geeks,
Here is an interesting blog post on "Dedicated Administrator Connection (DAC) in SQL Server"
Hope you will find it ...
Dedicated Administrator Connection (DAC) in SQL Server sqlservergeeks.com
Hi friends, Here i just want to inform you the power of Dedicated Administer Connection (DAC) in...
Perform Routine Server Checks Using PowerShell databasejournal.com
Database administrators tend to perform a lot of routine checks, referred to as sanity checks, on a daily, weekly, and monthly basis. Rob Gravelle shows you how to write some PowerShell scripts to automate a couple of fairly...
Pradheep
Ron
SQL Server LifeStyle - A New Way for the DBA myemail.constantcontact.com
JNetDirect is excited to provide this new solution to our product list: SQL Server LifeStyle! SQL Server LifeStyle is a technical analysis tool of SQL Server instances and their databases, analyzing over 90 parameters. SQL...
