Database Architecture Question - Hi, I know there's always 100 different ways to skin a cat, so I thought I'd see what you recommend... My organization...
SQL Server 2016 DBA Training - Hi people, I've been working as a SQL developer for a number of years, with an increasing amount of DBA work...
Session Context In SQL Jobs - I have setup a job to test if session context could be used across job steps. From what I can...
Compilation lock and blocking - Hello, We are seeing compilation lock blocking on one of our production server. Initially we saw it was because of the...
SQL Server | Architecture design - - Hi Experts, I have couple of basic queries regarding the way SQL Server is designed/works: 1) Schemas in SS is bit different from...
Management Studio freezing after writing a few lines of code - Hi all I've got a bit of an odd scenario. We're using SSMS 2012 against an 2012 Business Intelligence SQL install. Sometimes (it...
Can you reorganize this SQL stmt please ? - This doe snot throw errors but it does not pass any rows ( I mean it just goes on forever ) Some...
Help me rearrange the SQL statement - It works but ? - Folks I got this off of a SSRS report. This works fine. However I can't seem to make sense from this. I...
Grant Execute Permission on sp_audit_write - I got "sp_audit_write" working but only with ids granted to SYSADMIN. Looking at Microsoft documents, the only permission required is...
Query on locks taken in a Deadlock - Hi All, I’m wondering why one of the processes (4025498) involved in a deadlock has taken an IX lock on object...
How to join these tables together - How to join Employee and Student tables with HR table, - using ID and date columns to join with effective dates...
redesigning table to accommodate new data types - i have a table in which there is column called Marks of type int. This is used to save the...
SQL Files open in a new SSMS instance - When I double click on a .sql file, it starts up SSMS and loads my file. When I click on...
HDD Space problem when running queries - Hi, all. We are running SQL Server 2008 on Windows Server 2008 (both 64 bit) and I am running into...
Create From and To dates - Hi, I have the @rent table as below which holds the tenant rent charged values. The table has inconsistency as there...
SSRS How to trigger subscription when data is ready - hi guys, I have a few Reports that are subscripte bei a normal subscription meaning having a fixed time where it...
T-SQL Code Analysis Tools - I am researching T-SQL Code Analysis tools, like the equivalent of an FxCop for T-SQL that will scan thousands of...
bcp row terminator - I am trying to export the contents a query into a ASCII file. I need the character "LINE FEED" to be...
No PKs on fact tables - I just inherited a data warehouse where none of the fact tables have a primary key (all fact tables are...
SQL Server DBA Certification - Hi All: I want to become a certified DBA, i'm not sure what path is the right one. I have exprience...
