XCOPY failing via xp_cmdshell - I am trying to copy files from our hosting site server to pur local server with XCOPY. If I log...
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...
Getting data into SQL Server - Hi, Working for a small organisation and we now have a need to stop using spreadsheets to store data and move...
Server shutdown - I see in the event logs as below. What could be the reason. Any idea? The previous system shutdown was unexpected.
Installing SQL Server: How much space to allocate for each drive? - Hi everyone, I'm in the early stages of installing a 2012 instance and am unsure how much space I should allocate for...
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...
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...
How to archive old data from sql database - I have some data being written to a sql database, by requirement I need to retain the data for 1yr....
upgrade/ migration from Sql Server 2008 R2 ent ed x64 to 2012 ent ed x64 - Hi All, i would like to hear from you advice regarding my approach on performing the upgrade/ migration of my existing...
Removing Reverse Duplicates - Hi all, I've been racking my brain all afternoon with this one. In their wisdom, the developers of this database many...
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...
Syntax issue in sql query - Hi , I need some help in a sql query. I have an existing query: SELECT CAPBANK.BANK_LOAN, CAPBANK.LOAN_YEAR, CAPBANK.LOAN_NUM, (SELECT TOP...
How Do I Find Who Last Edited a Record or Table in a Database? - I have the following query built: USE MyDataBase; GO SELECT DB_NAME(ius.) AS , OBJECT_NAME(ius.) AS , MAX(ius.) AS , MAX(ius.[last_user_s
SQL Server 2008 R2 CPU Blunted Spikes - Hi there, I'm looking for suggestions for statistics I could monitor to discover what could be causing the cpu "blunted spikes"...
steps to restore database - Hi Team, I'm trying to restore a database on sql2008 environment. I have the full backup. can u please let me know...
Index and or constraint - I have this table CREATE TABLE .( IDENTITY(1,1) NOT NULL, (50) NULL, (50) NOT NULL, (1) NULL, -- number of columns...
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...
Recomended Hyper-V Memory Settings - I am seeking insight on memory management for Hyper-V. I have reviewed much of the material on Virtual Memory available...
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...
QUERY: GET SPACE USED/FREE in All Databases - Hello again, I need to get the following information: - Space Allocated from each database, - Space Used and from each database and...
