Topics
Started by
Posts
Last post
Hi there In the following example, I have a log table which captures events in a database Now it re…
10 replies
Hi There pls assist. I am trying to create a package that will query sql server and return results …
8 replies
Hi, I need to get hundreds of SSIS Packages from the MSDB database out to a Windows folder.The only…
3 replies
I am using Ola Hallengren's script for DB integrity so I tested the script 1st on our dev environme…
3 replies
A portion of our OLTP DB has 12 years of data, but have clearance to purge all data over 2 years ol…
7 replies
I have the following statement and I need to use a variable like so: declare @WhereClause varchar(m…
5 replies
Hi,I am researching about prefetching in Nested loops and can find some articles talk about that. M…
2 replies
Our production database is 700 GB but only 400 GB is used. Our destination server has only 500 avai…
4 replies
TABLE Ayear title country age2018 MR UK 502018 MS UK 40 TABLE B…
3 replies
Guys I am getting the following when I was trying to execute my SSIS package. Error: Variable "User…
2 replies
In a development SQL database I’m using I had the problem that my primary key columns were overflow…
1 replies
Hi again, I've done a little research but it seems I might be using the wrong vocabulary to search.…
2 replies
I m getting this alert below and i cant understand why since this is on the DR server where the dat…
2 replies
Hi , If I have a log table with around 30 columns in database DB1.Now, from 100 other databases DB2…
1 replies
Hi all, Recently, we've had an issue with disk space on the server that houses our .mdf and .ldf fi…
8 replies
Viewing 15 topics - 466 through 480 (of 30,225 total)
You must be logged in to create new topics.