And/OR logic in SQL - Guys, Maybe most of your guys it is Simple question and it is simple question but I am a little...
Why do some DBAs avoid DATETIME2? - I've been considering using DATETIME2(3) over DATETIME for new work due to the 1-byte saving of equivalent values (DATETIME2(3) vs...
Wrong Alert? - Hello I have created a job which send me an alert when D drive(dedicated drive for tempdb) free space is less than 2048...
trans log file growth - I'm using Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (X64) Jun 17 2016 19:14:09 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based...
SQL 2012 to 2014 upgrade - We have SQL Server 2012 Standard edition server and planned to upgrade to SQL Server 2014. This is the data...
Index fragmentation - I have a table with two indexes. It has showing 60% fragmented. So tried rebuild the indexes. Still indexes are showing...
SQL server 2014 is very slow - Based on this report(performance monitor) can any one tell why the Sql server is running slow. many application have slow...
Query displaying redundant data for a menu item, menu has choices, but displays menu item multiple times with different choices - Ugh, I know that topic was ugly...Ill try to explain this as best I can...I am writing a report for...
Using DB email sending emails to 30000 users - Hi All, I have one table where there is a column that have email id's for more than 30000 users , using...
Find user connections to SQL server tables - I want to check, how many users are connected to any particular SQL Table and cube (SSAS). This will be...
Update Statistics - Hi All , I would like to know how often we need to update statistics for all databases ? I need to create...
Converting User SID Binary to String TSQL - Hello All, Basically I'm trying to use TSQL to convert user SIDS from Binary to String and visa versa but I'm...
Need help to perform Weighted avg calculation to update back to table - Hi all, Actually i am working in banking domain. Our company has decided to change the data provider, so all the...
Split column value to rows. - Hi All, I was looking for code to split column value into separate rows.. Any help on this.. like for the example below...
Comparing Tables with Not Exist and Multiple Conditions - Hi, I'm trying to compare two tables, find results from T2 not in T1 with conditions. Below is what I have: --create table-- create...
ssrs 2008 final report totals - In an existing ssrs 2008 report, I want to add final report totals. I want the total line to be...
How to Add Data Conversion task dynamically - I am creating metadata driven SSIS package OLEDB Source to Excel Destination where Data conversion task required and need to...
Question about Mesure groups/partitions - Hello, I passed my exam 70-467 and I had this question, please do you know the reply ? Thanks. You are designing...
Update on differences in table types (temp/var/user) - I'd like a short piece that explains the differences between temp tables, table variables, regular tables, user defined table types. When...
Open SSIS packages in BIDS - SHort simple article that shows how to open a package from any store (SQL Server, File system, etc.) in BIDS
