Viewing 15 posts - 2,581 through 2,595 (of 8,761 total)
Start by having a look at these two articles
😎
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]
December 6, 2016 at 1:31 am
Quick question, have you tested if @i ever becomes NULL?
😎
WHILE @i IS NOT NULL
...
SELECT @i = min(Id) FROM @Alarms WHERE id > @i
December 6, 2016 at 1:26 am
I prefer using Extended Events when working with MARS result sets, little bit more work but cleaner to process especially if you take the result straight into Excel or PowerBI.
😎
One...
December 5, 2016 at 9:54 am
sqlguy-736318 (12/5/2016)
Then I exec'd...
December 5, 2016 at 9:32 am
Quick question, why are you using float?
😎
The value returned is exactly the same, but in scientific notation. You can change the last parameter of the Convert function which will...
December 5, 2016 at 5:58 am
rodjkidd (12/5/2016)
I'm in London all week, and free lunch times. Although today I'm waiting for the Royal Albert Hall booking line to open...
So let me know when you...
December 5, 2016 at 4:07 am
BOR15K (12/5/2016)
December 5, 2016 at 3:14 am
Tatay_2016 (11/25/2016)
First time here. I'm the admin of a small business with a mssql database that is remotely hosted by our website provider. I need to import/export...
December 4, 2016 at 12:15 am
ScottPletcher (12/2/2016)
ALTER DATABASE SQLTRIX SET OFFLINE WITH ROLLBACK_IMMEDIATE;
And you can get into devilish issues with "SINGLE_USER". You need to make sure...
December 2, 2016 at 9:11 am
HappyGeek (11/30/2016)
Eirikur Eiriksson (11/30/2016)
HappyGeek (11/30/2016)
DBCC TRACESTAUS runs without error.And the output?
😎
Sorry, yes there are no active traces
The DBCC TRACESTATUS lists out active trace flags, has nothing to do with traces....
December 1, 2016 at 3:47 am
Thank you for this write up Kenneth.
😎
November 30, 2016 at 9:02 am
Quick suggestion
😎
USE TEEST;
GO
SET NOCOUNT ON;
;WITH SAMPLE_DATA(SD_ID,SD_TEXT) AS
(
SELECT 1,'AA' UNION ALL
SELECT 2,'BB' UNION ALL
SELECT 3,'CC'
)
SELECT
...
November 30, 2016 at 7:23 am
HappyGeek (11/30/2016)
DBCC TRACESTAUS runs without error.
And the output?
😎
November 30, 2016 at 2:05 am
Andrew P (11/29/2016)
After doing some research on this, I'm aware I can identify...
November 30, 2016 at 1:50 am
Mike Scalise (11/29/2016)
Has anyone been able to successfully use Ola Hallengren's maintenance scripts to only clean up old backups and not take a new backup? I have full backups running...
November 29, 2016 at 10:09 am
Viewing 15 posts - 2,581 through 2,595 (of 8,761 total)