Partitioning Data on First Character - Evening Guys, Let's say I have a table with a couple of billion rows of data. That I want to partition....
SQL Server 2016 RTM (13.00.1708.0) Database Mail Not working - Hi Does anyone have database mail working with SQL 2016 (Standard Edition) and the Critical update 3164398? I've configured DB mail on...
replace text in large number of view and procedure definitions - I want to find and replace one particular word (happens to be the name of a database, which I know...
Pivot basic question - All, Apologises for the basic question. I have the following pivot: DECLARE @SQLStr
order by predefined list - Hi I would like to issue the
How to encrypt Credit Card numbers? - We have now finally moved all our customers to SQL 2014 from old or very old SQL versions and I...
disk space after deleting records. - I was running out of space so I ended up deleting some records from one of the biggest table I...
Intellisense on some databases, not others?? - I have an issue in SSMS that I can't figure out. In SSMS, connected to an SQL Server 2012 instance (Enterprise...
Return parents for children with certain condition - Ok, so here is my sample data I am testing against... declare @t table ( Id int , Section int, DateOccured DATE, Missed int ); insert into...
Column Length - Dear All, Question regarding the length of a column . As its understandable it has to be in accordance with the data...
Display commands and results to the screen or file using SSMS - Hi I want to run a long list of disable accounts & update password commands in sqlserver using SSMS. I want to...
Script to Clean up Trace Files? - Does anybody have an already packaged method to clean up trace files that have reached a size threshold? I have...
Procedure to upgrade SQL Server on same server - Hi Experts, We have been asked to upgrade SQL server version on a number of STAND ALONE as well as CLUSTER...
Mortgage amortization table - *** EDIT 2015-03-04: please be advised the code I posted originally below was in need of some improvement, and Solomon...
SQL Server Mirroring Issue - Hello, I have SQL server 2008 R2 Enterprise edition 64 bit in Principle and Mirror Server and SQL Server 2008 R2...
Multiple Calendars Using Kimball Outrigger Technique - Has anyone successfully used Kimball's outrigger technique for multiple corporate calendars in SSAS? If so, can you share the technical...
Column Arrangement - Hello, I would like to understand about column arrangement in multi table relationship as mentioned below 1. Job Planning Header 2. Job Planning...
A user you are following, "...", has posted new content: but I'm not following this user - Today I received an email A user you are following, "...", has posted new content:but I'm not following this user "Thom A", has...
Openrowset and Microsoft.Jet.OLEDB.4.0 - Hi, I have seen quite a few requests for help on the subject of importing data from Access and Excel...
best practices for Access to SQl conversion - One our network we have an Access front end and back end. The front end contains the queries, forms and...