I have a hugs DB and one table in particular is missing rows. I know this to be true but I need to find the gaps and show them. The primary key is the sequence number column. I need to show the actual missing sequence numbers. This table has 76,054,525 rows of data.
I'm trying to "describe" a table for a different post I have on StackOverflow, but when I run sp_columns, no results or rows are shown.
sp_columns assignee
Results:
A bunch of column headers...
What's wrong with my database, and why doesn't this work?
My favorite IBG story concerns the MVP listserve. Apparently there was always this back and forth on various problems and how to solve them. Except when he posts questions and then invariably it's just silence as people are trying to figure out what plane his mind is on
I'm trying to copy data from one db to other though Sql managment studio.
So, in the first db I created View and when I tried to transfer all data from that view to second db I got info message that only 1000 rows transferred, but there is much more rows in the 1st db. Does anyone know how to avo...
What do you mean by "sorted"? By definition, a table is an unordered set of rows. Do you actually intend to populate a column called sort_position? Can you clarify? What would be the point of this, when any query that selects the data can say ORDER BY surname? — Aaron Bertrand8 secs ago
@njk I have a stored proc that contains 4 separate queries all generated via dynamic sql. 3 of them I have been able to rewrite to not use dynamic sql. but this last one is a pain since they pass in the columns to order by
@bluefeet sometimes dynamic SQL is the best option. Think about a plan that favors a certain ordering, do you really want to use the same plan when the order is completely different? performance could suck...
@bluefeet but if you don't care about plan quality, dynamic SQL shouldn't be required for dynamic ordering. Just a matter of lining up data types and directions using CASE
Silly question. We have a named instance devIntegration\ALDERAAN Also has devIntegration\CMS I noticed a developer connect to Alderaan in SSMS by just typing in devIntegration What is this voodoo?
Yes, 18 months ago they added a new series of boxen to support our integration efforts. Default instanced boxes and the simply named instance SQL2008 were to be turned off.
Since we might go to 2012, they didn't want to have a named instance with the product and so they decided on Alderaan. Nothing says professional like having a stupid, unchangable instance name.
I ain't bitter though
@MikeFal Just referenced your eating an elephant analogy. I know you didn't come up with it but I first herd it from you ergo it's yours
@PaulWhite ha ha, awesome. I've had e-mail messages from StackOverflow users with 15kb worth of query text. Accompanied with things like "need help ASAP! This query is broken!"
@bluefeet hmm, not sure, I think in most cases it's on-site behavior that leads to that. Often when I get an e-mail there is no association to a stackoverflow account other than "I saw you answer a similar question on stackoverflow"
Mac 'n' Windows. Whatever next? Microsoft and Oracle?
Microsoft backs Oracle against Google in Java case and hires big shot atty, former SG Greg Garre, to lead the effort http://newsandinsight.thomsonreuters.com/Legal/News/2013/02_-_February/Microsoft_sides_with_Oracle_against_Google_in_Java_appeal/
@AaronBertrand still, you've gotta admire the stones of the person who's willing to drop in on a site and start copying and pasting stuff from recognizable sources
So, I've recently taken ownership of remote upkeep of a Windows 8 computer for my nephew (age 11) who I've helped take care of since he was about 3 for the most part of his life, including driving him to school every day for like 2 years. He now lives in Houston. The other day a post of his on FB scrolled past on my feed.
The other little 11 year olds leaving comments were things like "ur more gay than I am and I suck cock" and the like. As well as some bullying style comments (they're 11, they haven't quite developed the nuance)
@AaronBertrand His mother is in on the loop, but she works evenings. She's college educated and wants the boy to do well. The paternal situation is much more complicated.
I agree, they don't need accounts, but I'm overruled on this one, so the best I can do is just watch and make sure they behave as best I can. I can't be there all the time, but I can give corrective guidance.
Anyways. Just dropped that screenshot onto my sister-in-law's phone.
So if he is 11 why is he on facebook? Seems a simple fix, however that doesn't eliminate the same kind of behavior in 8000 other social media networks, never mind real life. <shrug>
@AaronBertrand I know. I am of the impression it's better to indicate what's right and wrong, and eventually just shut up and let him handle it himself.
But he hasn't had a computer to use to login to FB on a regular basis in the past.
So this is like the private beta of him having a SE site ;-)
In a month or so he'll be public beta for a few months, with the occasional check-in and see how he's doing.
but fwiw, at 11 years old, I didn't even have cognizance of "sucking cock".
I barely had cognizance of the more developed teenage girls at the table around me who were discussing bathing suits and asking my opinion on what they should wear.
As in, 33 year old me wants to explain to 12 year old me how boy-girl relations work and I might have stood a chance of understanding girls back then :p
@swasheck oh, I didn't say I wanted that boy to be dating, I wanted him and his analytic mind to have an appreciation of the interplay of vaguery and how some interactions were even more difficult to interpret than I understood then.
I've never understood the mob
I have learned to control it and focus it and even to deal with stray members so long as they conform to certain social normative patterns.
But I'm not part of the mob, and never will be, except in one regards. I have learned how to recognize the behavior of power grabbing, and will when the situation is appropriate make a power grab if I can.
I have a hugs DB and one table in particular is missing rows. I know this to be true but I need to find the gaps and show them. The primary key is the sequence number column. I need to show the actual missing sequence numbers. This table has 76,054,525 rows of data.
I'm trying to "describe" a table for a different post I have on StackOverflow, but when I run sp_columns, no results or rows are shown.
sp_columns assignee
Results:
A bunch of column headers...
What's wrong with my database, and why doesn't this work?
create procedure sp_tables_info_rowset_64
@table_name sysname,
@table_schema sysname = null,
@table_type nvarchar(255) = null
as
declare @Result int set @Result = 0
exec @Result = sp_tables_info_rowset @table_name, @table_schema, @table_type
go
After created, grant a...
