Viewing 15 posts - 16 through 30 (of 1,064 total)
You are executing the last 2 statements regardless of how many rows exist in the table. I assume this is the logic you really meant...
if (select count(0) from CGL)...
March 7, 2016 at 4:14 am
So if the count on its own runs quickly, does this construct work...
select @CT = count(.....
if @CT > 0 do stuff
February 23, 2016 at 2:38 am
If the system "is not written to work with transactions", then you run the risk of having a transactionally inconsistent database any time the machine or SQL Server or the...
January 26, 2016 at 6:02 am
Have you tried tweaking the Replication Agent Profiles? Specifically, the CommitBatchSize and CommitBatchThreshold values.
The default values for these can group a lot of publisher transactions and...
January 13, 2016 at 2:32 am
When selecting from the server, where are you running the command?
If you are running the select from your PC, then it's going to take some time to transfer...
November 20, 2015 at 7:48 am
Maybe not quite as bad as the VW situation, but Peugeot were caught a few years ago manipulating the odometer on vehicles. Every so often, it would add a...
November 16, 2015 at 7:51 am
All you're doing is running sp_start_job, which is presumably successful, and therefore you don't get an error.
It doesn't then hang around for the job to complete, so if it fails,...
November 13, 2015 at 3:44 am
Assuming group_chart_code_1 is an integer, this should work
Update test_Chart_Code SET group_chart_code_1 = group_chart_code_1 / 100 * 100
November 11, 2015 at 7:40 am
Although it doesn't actually list the differences, if you use the -f switch in Tablediff, it will produce the SQL to fix the differences for you.
November 9, 2015 at 4:55 am
Luis Cazares (10/30/2015)
[And that's exactly as I understand it. In my opinion, nulls and empty strings shouldn't be interchangeable.]
OK, I can relax again... I was beginning to think you were...
October 30, 2015 at 7:37 am
I believe that most theorists would prefer blank spaces instead of null values.
Really? I understand the grief nulls can cause, but without them how do you know something...
October 30, 2015 at 7:06 am
One possibility is to cross join the table to itself (you may want to tone that down a bit if the table is large) and give the matching columns a...
October 8, 2015 at 9:14 am
vedau (9/27/2015)
Doing an index maintenance right after the FULL could reduce the size of the Diff backup.
What makes you think that would reduce the size of the Diff?
It's likely...
September 28, 2015 at 2:01 am
Why are you running a differential backup every 3 hours? Don't forget, a differential backup backs up every page that has changed since the last full backup, so will...
September 24, 2015 at 3:54 am
Does the service account you are starting SQL Server with have the "Write Public Information" privilege in Active Directory?
September 22, 2015 at 7:45 am
Viewing 15 posts - 16 through 30 (of 1,064 total)