Topics
Started by
Posts
Last post
What am I missing? The datastage team insists that their connection fails when I have permissions …
5 replies
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
Viewing 15 topics - 6,766 through 6,780 (of 30,188 total)
You must be logged in to create new topics.