Viewing 15 posts - 19,111 through 19,125 (of 49,552 total)
SSIS packages or merge replication with filtered subscriptions. If I was doing this, I'd probably go with SSIS packages since it's a once-a-month sync. Merge replication would work too, probably...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 15, 2012 at 5:55 am
Open the MSDN library for the ADO.Net classes and read up on the parameters collection. It's really not hard and I know the docs have a large number of examples...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 15, 2012 at 5:52 am
hbtkp (4/14/2012)
they both are datetime.how to compare two dates with <=
Oddly enough, I showed you in an earlier piece of code...
IF (@Date1 <= @Date2)
Simple as that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 15, 2012 at 5:51 am
Merge replication looks like overkill here. If all that's needed is to copy data once a month that's a simple ETL process with SSIS packages, scheduled in SQLAgent most likely.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 14, 2012 at 12:16 pm
Don't concatenate values into a string and execute them. It's a major security hole and it hinders performance.
read up on the ADO.Net parameters collection and use that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 14, 2012 at 12:13 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1283659-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 14, 2012 at 12:12 pm
GilaMonster (4/14/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 14, 2012 at 8:13 am
hbtkp (4/14/2012)
my function doesnt have base tableit simplylike this
create function name(@Reportdate1)
return table
(
column1 datatypr,
column2 datatype)
Not possible. That is not a complete...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 14, 2012 at 7:55 am
hbtkp (4/14/2012)
i need to insert in fitem3,but as it is function,i cannot insert into it.so what i need to do,can i create temp table and then insert into function
No, there...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 14, 2012 at 7:29 am
a) No, it won't because there must be no other users. You must quiesce the database before enabling the option, single user mode though is not required.
From Books Online:
When the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 14, 2012 at 6:07 am
balasach82 (4/14/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 14, 2012 at 5:29 am
Have a look at MeasureUp and Transcender. They both sell practice exams. Some of the exam guide books also have DVDs with practice tests.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 14, 2012 at 5:27 am
1) no
2) the multiple files applies to data files only.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 14, 2012 at 3:48 am
Braindumps are cheating. They are actual questions taken from the exams in violation of the NDA that all exam takers must accept. Using or distributing braindumps can result in your...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 14, 2012 at 3:46 am
1) no
2) no
3) increased load on TempDB, possible change in behaviour (update conflicts instead of lost updates). Do test the app on read committed snapshot before just switching production over.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 14, 2012 at 3:45 am
Viewing 15 posts - 19,111 through 19,125 (of 49,552 total)