Viewing 15 posts - 1,921 through 1,935 (of 13,469 total)
adding some background, because i didn't know what 610 did, let along as it pertains to availability groups
http://sqlblogcasts.com/blogs/simons/archive/2010/11/17/trace-flag-610-when-should-you-use-it.aspx
Thanks to Marcel van der...
March 3, 2015 at 1:09 pm
to find the percentile, you need the age, gender and BMI. then you could use a lookup table.
Body mass index-for-age percentiles: Boys, 2 to 20 years

March 3, 2015 at 1:00 pm
i had a similar issue, which might help.
i wanted to start adding filtered indexes...indexes with WHERE statements; as soon as i added the first one, some processes started throwign that...
March 3, 2015 at 12:52 pm
it SO depends on what you want to export.
what is actually in the PDF? a tablular looking/rows and columns? colored headers?
it's very easy to export to HTML from SQL, as...
March 3, 2015 at 9:01 am
i think your implementation of concatenation on either one is wrong.
'121'+'34' or '12' + '134' = '12134', which is a problem with your calculation.
whether hasbytes or either of...
March 3, 2015 at 7:12 am
while it's possible to search every column in the database for a specific value with a big old nasty slow cursor that cripples other users performance while you are using...
March 3, 2015 at 6:44 am
can you convert it to varchar(11) in your report datasource?
this produces the expected format, and cuts off the trailing zeros from a simple CONVERT(varchar,@CPUTM)
/*--Results
(No column name)(No column name)
00:00:00.8200:00:00.8200000
*/
DECLARE @CPUTM [time]...
March 2, 2015 at 2:44 pm
i forgot the alias for the max:
MAX(ais_data.mssisdtg1) AS mssisdtg1
select
ships.name,
ais_data.mmsi,
ships.country,
ais_data.course,
ais_data.sog,
ais_data.heading,
...
February 27, 2015 at 1:54 pm
it looks like some inline strings/code that is being constructed in c#, which is then being executed, presumbly by LoadDatatable?
i'm not sure where =\'" + dtg + "\' is...
February 27, 2015 at 7:19 am
mw112009 (2/26/2015)
You can share yours if you like.
The only good thing is he had written in in such a way that...
February 26, 2015 at 2:11 pm
maybe this one from Narayana Vyas Kondreddi?
I've been using a modified and renamed version of his for years.
February 26, 2015 at 1:29 pm
the end user is going to be using TSQL to send files to disk, or is this some sort of automated process that you are envisioning?
in my case, i have...
February 26, 2015 at 1:22 pm
krypto69 (2/26/2015)
I found a few 'SearchAllTables' scripts out there to help me find a value in any table/column/row of any Database.
My problem is that none of these database search queries...
February 26, 2015 at 12:30 pm
recursive CTE is the way to go. no doubt about it, and no way around it.
just stick the top results of your recursive query in a temp table or...
February 26, 2015 at 8:08 am
arrjay (2/26/2015)
Perfect! Thanks.The results don't include objects which have not been written/read to/from i.e. nulls. Is there a way of returning these stats? Thanks again.
pretty...
February 26, 2015 at 6:57 am
Viewing 15 posts - 1,921 through 1,935 (of 13,469 total)