Viewing 15 posts - 616 through 630 (of 1,999 total)
hey, i'm only putting options out there - I don't have a full solution , just trying to help people think of solutions for themselves. 🙂
personally, i'd end up going...
November 28, 2019 at 2:45 pm
change it from using the mapped drive "Z" and use the UNC path - first step, I suspect that sql can't map the Z drive
November 28, 2019 at 2:37 pm
what are you trying to audit?
you can audit data changes (you'll get lots of suggestions), maybe schema changes (that one is my speciality), configuration changes ?
in sql server management studio...
November 28, 2019 at 2:33 pm
Those of us who follow ISO standards use 0=unknown, 1= male, 2= female, 9= lawful person (churches, corporations, etc.) And make the column not null.
and i'm laughing now because...
November 28, 2019 at 2:24 pm
Those of us who follow ISO standards use 0=unknown, 1= male, 2= female, 9= lawful person (churches, corporations, etc.) And make the column not null.
do you have a link...
November 28, 2019 at 2:22 pm
you need to use a table of dates (possibly a recursive CTE) and figure out how to put the last working day's value in to the table.
I think you might...
November 28, 2019 at 2:11 pm
This sounds like a good use for rownumber() over (partition by … order by …)
partition by the date - not sure how you would go about it. - but scdecade...
November 28, 2019 at 1:56 pm
it sounds like either your apps are not closing connections, or that you are not using connection pooling correctly
if you have 100% of your cpu trying to manage context switching...
November 28, 2019 at 1:11 pm
You could. Depending on what you're doing, that's a lot of data movement
grant has hit the magic words - data movement
write once , read many - don't keep writing...
November 28, 2019 at 12:54 pm
I've tried getting service broker, hierarchyid, graph and many other things... nobody wants to step out of their comfort zones.
What did you want folks to use HierarchyID and...
November 28, 2019 at 9:00 am
Jeff , you are anything but brief. keep it up
and I have a migraine from trying to figure out that last message - yay, I get a day off -...
November 28, 2019 at 8:50 am
this is just an opinion.. I have a few servers that have tempdb that "misbehaves".
this is normally transactions that don't commit - or an index operation at the weekend
best practice...
November 27, 2019 at 4:19 pm
all the guys are right on this. if you perform a function on every row in a where clause you will die very quickly - you can't use a function...
November 27, 2019 at 2:44 pm
Just remember NULL does not evaluate - but try and avoid doing ISNULL(myfield,'')
you end up checking for blank spaces and NULL everywhere.
I've found that default values can help SQL a...
November 27, 2019 at 10:45 am
In management studio you have a number of reports that can show you this
I like the performance dashboard
look out for the buffer cache hit ratio - 100% is good, another...
November 27, 2019 at 10:05 am
Viewing 15 posts - 616 through 630 (of 1,999 total)