--late edit: i only saw page one of three: there are better solutions later in what i saw!

i can get that result with a union:

SELECT *,

...

Perry Whittle (1/29/2015)

---

Convert it to what?

just divide it by 1024 will give whole...

this is about the simplest i can see... when you say round up, does that mean 3.199 meg gets rounded to four, or to 3.20?

a meg is 2^20 power, right?

/*--results

Megabytes

---------------------------------------

3.20

*/

Declare...

your where clause requires a full table scan that cannot use an index, becuase the search criteria looks for matches int he middle of the string.

WHERE si.TrackingNumber like '%' +...

pilikowaty (1/29/2015)

---

I though so..

I was wondering, if there exists such a tool, which lets users to search a sequence of numbers (strings)

For example. Im looking for measurement of id:123123.

So...

pilikowaty (1/29/2015)

---

Thanks a lot. 🙂

Is there one more possibility to create tool - search, directly on report server, f.e. for client, who hasnt got access to server management, he can...

a transaction log is like a box : it's dimensions(size) do not change, only how full or empty it is.

So truncating the log empties the box to make room...

well, first you need to make sure you've set up database mail, but a it's just a simple conditional logic.

here's a template that i use a lot:

IF EXISTS (SELECT *...

you would execute that statementin SQL server Manangement Studio, connected to teh server that you know hosts the reporting services database.

for example:

select * from ReportServer.dbo.Catalog where convert(varchar(max),convert(varbinary(max),Content) ) like...

yep it can be done, but it's not obvious.

the actual rdl report is stored in an [image] datatype.

to search it, you have to convert it to varbinary, then convert it...

a CLR is a common language runtime object, which is not the same as a SQL inline table vlaue function, scalar function, or multi statement table function.

so while a CLR...

you can pass a table value parameter, which you have to define first, and then you can use it.

https://msdn.microsoft.com/en-us/library/bb510489.aspx

you can also pass a delimited string, and use a function...

i have this old example, which might help:

/*--Results

id ...

also is there an index on tb_dept(dname) ? sincethat's the group by, an index would help that specific query.

you can query all tables in the entire database, and determine which have zero rows by taking advantage of the dmvs related to indexes and partition stats

with that, you...