Viewing 15 posts - 6,811 through 6,825 (of 7,168 total)
OK...I'll take a shot at this...
I noticed something in your Audits table design that should be mentioned...UNIQUEIDENTIFIER might be the worst choice on the planet for the first column in...
March 25, 2011 at 10:38 am
Do you know about TRY/CATCH? You can report on trapped error, but it only sees the last error so you'll lose sight of the "DBNAME does not exist error".
BEGIN TRY
...
March 25, 2011 at 9:43 am
If you're going from SQL Server to SQL Server I would use the native option of bcp instead of character ( -c ). Not only will it be faster but...
March 24, 2011 at 2:42 pm
Dang it Lutz...I was almost there! You got it!
March 24, 2011 at 1:51 pm
If the login is not linked to a user in the database then they will not be able to connect to that database.
To find the database user name for the...
March 24, 2011 at 1:23 pm
I think what you need is to aggregate over a partition based on the 15 minute interval. See if something along these lines works for you:
WITH cte
...
March 24, 2011 at 12:57 pm
Nevermind...memory failed me there...
March 24, 2011 at 12:48 pm
Please provide runnable DDL to create your tables, some DML to create test data and your expected output. Also posting the queries you are working with now will help start...
March 24, 2011 at 11:20 am
What is the value of the MaxMemoryUsage property on the Cache Transform?
March 24, 2011 at 10:25 am
You posted into a SQL 2008 forum....you may have better luck posting this in the DTS forum: http://www.sqlservercentral.com/Forums/Forum19-1.aspx
March 24, 2011 at 10:21 am
srinadh.ramineni (3/24/2011)
But the performance is the key here. Other than BCP any alternative?
BCP is very fast and should do fine for this task. BCP will handle exports with a very...
March 24, 2011 at 9:47 am
OPENQUERY is your friend. It guarantees the query will be executed on the remote server.
With 11 tables, most of which are on the remote server, you have your hands...
March 23, 2011 at 4:16 pm
How about something along these lines:
IF OBJECT_ID(N'tempdb..##missing_index_info') > 0
DROP TABLE ##missing_index_info
GO
CREATE TABLE ##missing_index_info
(
[index_handle] INT,
[column_id] INT,
[column_name] NVARCHAR(4000),
[column_usage] NVARCHAR(4000),
[audit_date] DATETIME
) ;
go
INSERT...
March 23, 2011 at 12:33 pm
Invalid meaning you don't like it?
The schema generator generates a valid schema per the XML provided...but it takes a least-common-denominator approach. If you have constraints you need in your schema...
March 23, 2011 at 12:11 pm
Viewing 15 posts - 6,811 through 6,825 (of 7,168 total)