Topics
Started by
Posts
Last post
HI I am using sql server 2008 r2 sp 10 I have a database that originally consumed 500gb, I truncate…
9 replies
We have a VLDB that needs to be restored from a production to stage and dev servers on a monthly ba…
4 replies
Hello Experts, We are extracting data from multiple sources and staging the data in SQL Server tabl…
5 replies
As an accidental DBA who is really an accountant I could do with some advice. So today I was drivin…
7 replies
DECLARE @str varchar(255) SET @str = 'ABCD1234EFGH5678MARWOKELL85674INTE42569' In need to break th…
2 replies
IF OBJECT_ID('tempdb..#tempTEST') IS NOT NULL DROP TABLE #tempTEST; CREATE TABLE #tempTEST( RowID …
3 replies
Hi, I am creating an non clustered index on a table which has over 30 million rows in it as follows…
3 replies
We currently have a report on clinics, this report is ordered alphabetically, my project manager wa…
2 replies
I have a SQL Agent job on Server1 with 3 steps. The 3rd step is supposed to execute a SQL Agent job…
2 replies
I have the following view CREATE VIEW [dbo].[VW_QUERY1] AS SELECT t1.* FROM TABLE1 t1 INNER JOIN T…
5 replies
what are the adv and disadvantages of shrinking the database
3 replies
Hello. I have a SQL Agent job with the following steps: 1. Process 'ABC' Logic (SSIS Package) …
1 replies
business people sent me an excel file. looks like the picture. this is not very well data friendly…
11 replies
Hi - I'd like to create a view where I can select one value from the previous row in the table. Ca…
35 replies
Hi! New here and having an issue with an SSIS FTP task that up until yesterday has been working fin…
1 replies
Viewing 15 topics - 6,766 through 6,780 (of 30,225 total)
You must be logged in to create new topics.