Viewing 15 posts - 106 through 120 (of 616 total)
Sorry! I have updated my previous comment which explains the changes that I made!
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
November 4, 2013 at 9:24 am
A little bit of formatting + fix 😉
You don't need to include the schema name when you call the OBJECT_ID function:
OBJECT_ID(N'dbo.mtzcus_2014_CoreMenuAuditDetails', N'U')
should be just
OBJECT_ID(N'mtzcus_2014_CoreMenuAuditDetails', N'U')
IF OBJECT_ID(N'mtzcus_2014_CoreMenuAuditDetails', N'U') IS NOT...
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
November 4, 2013 at 8:59 am
CREATE TABLE dbo.SCC (
Col1 VARCHAr(10),
Col2 INT,
Col3 INT,
Col4 TINYINT)
INSERT INTO dbo.SCC (Col1, Col2, Col3, Col4)
VALUES ('Test1', 3016482, 56395, 3),
('Test2', 5489108, 57921, 2),
('Test1', 3016482, 56395, 3),
('Test3', 8079081, 89302, 1),
('Test4', 8789080,...
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
November 4, 2013 at 4:20 am
Use Jeff's string splitter function?
Tally OH! An Improved SQL 8K “CSV Splitter” Function[/url]
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
October 9, 2013 at 9:00 am
You're welcome 😀
Just noticed you may want to change the size of your @Result variable to more than 10 characters as the version number you're checking is 12 characters long?
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
October 7, 2013 at 9:49 am
Here you go:
DECLARE @ServerName AS NVARCHAR(50)
SET @ServerName = <YOURSERVERNAME>
DECLARE @sql AS NVARCHAR(1000), @Result AS NVARCHAR(10)
SET @sql = 'SELECT @theResult = CAST(Result AS NVARCHAR(50)) FROM OPENQUERY([' + @ServerName + '],...
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
October 7, 2013 at 9:02 am
Assuming you have the restore job scheduled as a SQL Agent job then why not add an extra step where you call a single stored procedure that contains the code...
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
October 7, 2013 at 5:33 am
If the database is still attached to the SQL instance then you won't be able to delete it via windows explorer.
You can either delete the database from the SQL Server...
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
October 2, 2013 at 5:03 am
Which datasource to use to copy data ?
SQL Native Client
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
September 27, 2013 at 2:42 am
Professional SQL Server 2008 Internals and Troubleshooting
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
September 26, 2013 at 7:50 am
I love SQL Compare!
Great tools at reasonable prices for sure. However, be aware that some of the tools like the SQL Backup utility can only be used for one server...
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
September 26, 2013 at 5:55 am
Didn't get the job! Boohoo! :w00t:
In the end the guy with the more team leading experience got it.
Just goes to show, getting through the second stage doesn't mean job guaranteed!
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
September 23, 2013 at 5:21 am
2 minutes doesn't sound too bad considering it's performing so many scans on your ReportRecipients table!
The only alternative I can think of (and I'm not even convinced it will speed...
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
September 23, 2013 at 5:14 am
Firstly, I would recommend a quick read of the below as a refresher:
http://technet.microsoft.com/en-us/library/ms186992(v=sql.105).aspx
I would change your code to the below:
WHERE
( ct.AlertedDate between @startdate and @enddate OR ct.[Dispo] = @STdrp...
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
September 18, 2013 at 7:39 am
SSAS /SSRS and SSIS are merely free tools that Microsoft kindly gives us when we purchase their SQL Server software. You install the SQL Server engine - then you can...
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
September 11, 2013 at 9:08 am
Viewing 15 posts - 106 through 120 (of 616 total)