Viewing 15 posts - 361 through 375 (of 1,995 total)
Thanks, Mike. I am also from the UK.
When I Googled 'chad', I ended up learning a lot about a country in Africa, but nothing about hole-punch waste! 🙂
whereabouts ?...
February 4, 2020 at 3:03 pm
do you have enterprise edition ? I would advise against the union solution - if you have enterprise then use table partitioning based on the date.
how often is the data...
February 4, 2020 at 2:50 pm
looks like it's the function
if you just run
declare @myNumber INT;
select @myNumber =...
February 4, 2020 at 2:44 pm
if i'm understanding correctly then I don't think there is a way. transactional replication relies on the t-log from the publisher sending stuff to the distributor and the subscribers collecting...
February 4, 2020 at 2:30 pm
Is 'chad' an American term? I have no idea what it means!
you know the little dots of paper that you have to empty from the hole punch... that's chad...
February 4, 2020 at 2:25 pm
JEFF Do NOT go all SSIS on me 🙂 we all know it's Bulk insert with a formatfile or openrowset
Jeff's blood pressure just went...
February 4, 2020 at 10:29 am
you might need to "GRANT CONNECT"
February 3, 2020 at 5:27 pm
I've worked on teams where the DBAs were considered to be ugly trolls hiding under the bridge just .
Hey - I might live in Mansfield, but we don't have...
February 3, 2020 at 4:15 pm
I absolutely agree that cooperation leads to learning. That's why I sit with the Developers and have a symbiosis with them. Cooperation does not mean letting bad stuff happen...
February 3, 2020 at 4:07 pm
When I cast everything to VARCHAR(), the AGE >= THRESHOLD comparison doesn't work correctly.
you need to give us a bit more - but if you are casting everything...
February 3, 2020 at 1:07 pm
at a rough guess you might make a loop (i'm assuming you have a numerical sequential value for your row)
something like
declare @rc int=0
while @rc>0
begin
declare @lastrow int=1
select top 75000 * for...
February 3, 2020 at 12:24 pm
syslogins will tell you who can connect - if you go into each database and look at sysusers when you will see individual permissions
but a sysadmin will have ALL permissions...
February 3, 2020 at 11:42 am
how many records in the table ?
February 3, 2020 at 11:33 am
if i'm reading this correctly - just turn it into an inner join
and for code clarity move the disabledflag=0 into the where clause... it has no place in the join
February 3, 2020 at 11:30 am
MVDBA (Mike Vessey) wrote:I'm not sure I agree on this one - cooperation leads to learning. rather than fight them we can mentor them
^^^^^^^^^^^^^^^^
YES!!!!
BE SQL YODA - "hmmmm, set based thinking...
February 3, 2020 at 11:14 am
Viewing 15 posts - 361 through 375 (of 1,995 total)