SELECT *
FROM master.sys.server_principals
WHERE IS_SRVROLEMEMBER ('sysadmin',name) = 1
ORDER BY name
Trace Skipped Records
An interesting issue that i saw it first time this week when using the profiler:
Trace Skipped Records....
Apparently that's what it sounds: the profiler was too "busy" or loaded, so it skipped few records...
"Busy"/loaded can be few things:
Long text that was caught and the profiler can't display it in TextData column, busy or loaded server or something in the machine where the profiler isd executing.
This thong is a known issue in Microsoft:
I didn't fing a lot about it, here 2 useful links:
select ... into ... union
declare @a table (aint int)
declare @b table (bint int)
insert into @a (aint) values (1), (2), (3)
insert into @b (bint) values (1), (2), (4), (6)
If you need to insert an union select into a temp table, like this:
select * into #tmp
from (select aint from @a union select bint from @b) t
You can also do it like this:
select aint
into #tmp
from @a
union
select bint
from @b
Check it:
select * from #tmp
(and also drop the temp table :) drop table #tmp )
Quotation marks in an exported csv file from sql
As probably known, we can export data to a csv file from the export wizard.
But, if the text columns have the “,” – that it is the column separate sign – all the csv file will be not arranged.
One possible solution is to declare Quotation marks to all columns, and it will help to separate the columns.
Update string add spaces to the input text
Can it be that we will try to update a string and SQL add spaces to it while updating the column?
Answer: Yes!
Char and nchar data types fill the string to the defined text.
An example:
If a column declared as char 3, and we will run
UPDATE MyTable SET CharColumn = 'AA' WHERE id = 1
and the value there will be set to 'AA ' !
Include columns headers in csv files via grid results
There are few ways to save query results to files.
One of them is direct from the grid results:
But, when you will do it, you will find the csv file without the columns names:
Not so nice…
The solution is quite simple: declare in the options to get also the headers:
Done. Try again – but again – no columns header!!!
Now what?
The solution for that is the most common solution in the IT world: restart – restart SSMS.
Next time – you will get the headers.
Subscribe to:
Posts (Atom)