conditional where clause - I have this problem I cannot solve. In a stored procedure I need to make a select query. A parameter...
DBCC Check DB - Over the last year our DBCC Check DB process has jumped from ~ 8-9 hrs to. ~ 25 hrs. I decided to...
Recommendation for better perfromance - HI I need recommendations for better performance of sql .we have 32bit SQL servers and want to make sure we...
Log Truncation and Database Mirroring - Hi all, I understand that mirroring is no longer recommended but the setup exists in my current environment I am trying to...
Unable to TRUNCATE TABLE, a permissions issue (I think) - When I execute Truncate Table [FS-JIREMSQL].JIREM10.dbo.JIRABConcentration in SSMS query window, it fails. The error code is: Msg 4701, Level 16, State...
Msg 3013, Level 16, State 1, Line 2 BACKUP DATABASE is terminating abnormally. - [code="sql"]BACKUP DATABASE [Staging] TO DISK = N'\\NetworkStorageLocation\ProjectA\Test_backup_2015_04_24_105955_2107357.bak' WITH NOFORMAT, NOINIT, NAME = N'Test_backup_2015_04_24_105955_2107357', SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10 GO [/code] Error Message that i...
Splitting a multi-delimiter string and update - So I am trying to fix something a developer did in our database and I'm having trouble figuring this out....
Transaction logs arent being truncated after backups - Dear DBAs I am running the following TSQL to backup my transaction logs once a day Yes i know you...
One to Many relations - Hi, I've a few different entities that need to hold photos (one or many), let's name them A, B and C....
Monthly total of active data - For a report I'm trying to write I ideally need a recordset that shows me how many people were on...
t-sql 2012 trigger - Would you show me how to setup a trigger from the items I listed below for a t-sql 2012 database? 1.I...
Parse street - Hi Guys, First post for me here, so i dont know if i am at the right place. I have a street...
Calculate time difference between two related visitors without using cursor - I have a table (see attached) listing visitors IDs, listed more than once, and Arrival DateTime. I need to find...
Error: 8355, Severity: 16, State 1 - Hi All, Our main server is set up with two external drive shelves. Yesterday we lost one of our external drives...
Index guidance needed - Hi everyone. I recently came across a dev database in our organization that had no clustered indexes and circa 100 million...
Forward dependencies are not valid - Hi, I have Test.rdll, with one parameter and one dataset Dataset: Name:Country Query: [quote]select distinct [Country] from [DW].[dbo].[Dim_Country] where Active = 1 and Country = @Country[/quote] Parameter: General; Name= Country, Prompt = Country,...
Export Integration Services Catalogs - Hi Experts, I need to transfer SSIS Packages which are under "Integration Services Catalog" under SSISDB. Basically I need to get packages...
How to force column explicitly to string type before we export to excel - I have a package which laods data to excel ,but my manger wants to force column explicitly to string type...
Delete files that are older than 7 days - I have a folder in d drive called Archive (d:\archive) which stores all data load files. The name of these...
sp_send_dbmail not working but send test e-mail for database mail working - I set up database mail on a sql server 2005 cluster and when I send a test e-mail form SSMS...
