Topics
Started by
Posts
Last post
I have two tables (TRIP and TRIP_DETAIL both have the same primary key called TRIP. There is no FK…
10 replies
Here is the scenario: Step1: Verify number of CPU's SELECT cpu_count FROM sys.dm_os_sys_i…
7 replies
I have a SSRS validation report that needs to run right after a ssis Job is complete in sql agent …
2 replies
Hello everyone, Little stumped with this problem trying to do a bulk insert into a table and it was…
3 replies
Are there situations where creation of an index on a temp table should be done at the time of table…
3 replies
I've written plenty of imports over the years, but I'm trying to find the best and fastest way to u…
5 replies
Hi all I am wondering what is best practice when a table has no natural primary key and no clustere…
2 replies
I have a deadlock situation that I am having some difficulty understanding. Attached is the deadloc…
1 replies
The SQL Server instance specified in SSIS service configuration is not present or is not available.…
3 replies
Hi geniuses! I have this query SELECT DISTINCT chapter, Sum(dbo.FGG.Value) AS FGG2010 FROM FGG WHE…
2 replies
Hi Friends, I am going to implement Transaction in a package. I thought of using the Transaction fe…
3 replies
I have recently moved RS dbs to test servers using the detach and reaatach method. What I didn't re…
2 replies
Hi All I have a query to fetch the starting day as "Monday" between any 2 selected dates. For eg: S…
1 replies
is there a way to find a table which has maximum no. of records among a table list of 100 tables. w…
7 replies
This seems as though it would be terribly simple...but I am stuck. I need to distribute as "average…
40 replies
Viewing 15 topics - 13,561 through 13,575 (of 30,214 total)
You must be logged in to create new topics.