I have a table,
FruitCrateID
FruitID
Now FruitID and FruitCrateID have a many-to-many relationship. I have a strongly typed dataset I need to create add and update stored procedure.
Now I can use foreach to add FruitID and FruitCrateID to database but there will be several calls for example,
...
i am trying to insert value in table page no wise.
ex-- if i click save front of 1 then it insert only 1 for main issue- dak.
if i click save front of 2 then it insert only 2 for main issue- dak. like wise..
but always it inserting page no 1 for all edition in table plz suggest me ...
i deb...
table-partitioning - 38 questions
partitioning - 247 questions.
Most questions tagged table-partitioning are also tagged partitioning.
The current wiki excerpt for partitioning is:
"Splitting a database table into multiple segments for performance or manageability."
Proposing we create a ...
Oh, and cool note on the job posting he sent me included this section: Preferred candidates would also meet the following criteria: • Involvement with the MSSQL Server Community; membership in PASS, active in forums or newsgroups. • Certification is a plus; MCTS, MCITP, MVP • Previous experience in either a teaching or volunteer role.
First one I have seen include "MVP" as a certification
@Zane Oh that is why my interest is so high, it is a State government contract. Last I heard it is good bit of money possible, my interest is just having full health benefits again.
@billinkc Yeah figured it...but there actually was two or three I had never seen before, "online" at least but I don't scour the Internet looking for them either
@PaulWhite so ... MVP awards aside, i have a question. this is probably covered in a blog post somewhere but i've not found it so far. when a query needs more memory than it's been granted, what happens? does it always spill, or can it request more and a broker decides if it can grant more?
@swasheck Memory grant is acquired before execution begins. It cannot be expanded after execution starts (except for index building). So, the scenario doesn't arise. A query that needs more memory than it has reserved spills.
@Zane well I was a state employee for 5 years and will not take that again. The recruiter with the company has kept up with me over the last 4 or 5 years on his own accord, which has impressed me. As well I have done military contracts since 2008 so I am more accustomed to that type of work.
There used to be kind of a vote. When I first joined the SQL Server group we used to get asked for our opinions on community members who were being considered. So we actually had some influence and it was a little more like Fight Club than it is today
@ShawnMelton yeah that is terrible - and it is much easier to give yourself points without having to create sock puppets
@Zane Wellington isn't tropical, as such. The top end of the North Island is kinda subtropical but Tropical isn't an adjective I've ever seen applied to Wellington.
Q: Why is it so windy in Wellington? A: 'cause Auckland sucks!
@billinkc i have a great gar recipe. broil on a wood plank with salt, pepper, green and red peppers, basil, onions for 30 minutes. scrape off the fish and eat the plank.
@PaulWhite Wrong city, but there's a curry place on Dominion road that's pretty good (at least it used to be when I lived there). Also Helen Clarke's favourite curry outfit.
@ypercube Not yet time for sleep. My wife had an operation on her knee several weeks ago, so the days are set aside for looking after her. If I want to do some SQL work, well that starts about 11pm :)
@PaulWhite I had some naga sauce (called Megadeath) that was rated at 550k SHU. It was pretty aggressive. Not sure I could be arsed with the eat-a-ghost-pepper-on-youtube challenge.
@PaulWhite When I was working in Lichfield I found a small cafe run by a foodie. She had some of this stuff and volunteered me as the guinea pig. We thought we'd start off light - just a teaspoon in a batch of baked beans on toast.
I sat down on my burning ring of fire - Johnny Cash after eating Megadeath sauce.
I'm not really sure what you'd use that sauce for unless you were a pretty hard-core chilli nut - to the point of being de-sensitised to the capsiacin.
However, they ran a challenge using two spoons in your baked beans. I think you got them free if you could eat it all. When they asked if I wanted to enter I politely declined.
Let's be clear, I'm not out to prove the length of my spicy food.....stamina. I just like a good spicy flavor and giggle at NZ's relative weak sauce when it comes to spice.
@MikeFal I had a friend from Thailand when I was at university. She once had a bag of chillies that were too hot for me to eat. She reckoned she wasn't even the main chilli nut in her family.
@ConcernedOfTunbridgeWells a high school friend's family hosted a thai exchange student whom i befriended. she made us a meal before she left. it was awesome.
Max, this might have been the best explanation if the user was like system, network, sqlserver agent. However in this case, if you login once as 'Max' it will show that many records for you. I don't think there's anyway anyone can login from the same machine, to the same instance at the same time. — Harp8 hours ago
As I clearly show in my updated answer above, it is very likely that any well-written client-side application may well open multiple connections to SQL Server, exhibiting the precise behavior you are seeing. — Max Vernon29 secs ago
@PaulWhite That would be awesome. Anything I can get you from my neck of the woods? I could probably find some green chile sauce if you like that sort of thing.
I have a select statement that when run on the live production server, returns mm-dd-yyyy regardless of what I do. this only happens though when selecting the date from an another aliased select. Simplified (as my sql is quite long):-
select name,age,dob from tblone as tbltemp1
in this select...
Transparent Data Encryption, by its very nature, doesn't change any of the internal processing of queries. TDE is designed to negate the need for application developers to make any changes to their applications.
http://msdn.microsoft.com/en-us/library/bb934049.aspx contains a salient piece of ...
I am trying to code in C# with DOT42. How do I navigate to an html inside my Assets folder. I have achieved the same wit Eclipse in java with the following Code:
Uncaught Error: SECURITY_ERR: DOM Exception 18
What is the setting for out putting the query result to pane, instead of text file. I set output to text file a long time ago. But I forgot how to turn it back. Please advise.
Thanksa
I have client's AG replica that includes databases that were suspended, and show last sent time to be more than a week. Is there possibility resuming data movement will have impact on anything specific that I should wait until off hours to re-enable?
We have on our DB some international people that got some characters saved incorrectly on our DB (MS SQL 2008 R2).
For example we have strings like 'WilcoxonÃ'.
We got this data into the db because we take international submissions but management didn't want to use any character set eve...
This construction is not currently supported in SQL Server. Applying one of the workarounds listed in the Connect item reporting this deficiency, your query could be rewritten as:
WITH UpdateSet AS
(
SELECT
AgentID,
RuleID,
Received,
Calc = SUM(CASE WHEN r...
Classic @PaulWhite quote: > This has the advantage of avoiding an Eager Table Spool for Halloween Protection (due to the self-join), but it introduces a sort (for the window) and an often-inefficient Lazy Table Spool construction to calculate and apply the SUM OVER (PARTITION BY) result to all rows in the window.
p. The SELECT DISTINCT, GROUP BY and ORDER BY clauses each implicitly create temporary tables on the server and thus are detriments to performance. Only use them when necessary per the following guidelines.
I have not seen any clear, concise examples of this anywhere online.
With an existing table, how do I add a self-referencing foreign key? For example:
CREATE TABLE dbo.Projects(
ProjectsID INT IDENTITY(1,1) PRIMARY KEY,
Name varchar(50)
);
How would I write a command to add a self-re...
I have a table,
FruitCrateID
FruitID
Now FruitID and FruitCrateID have a many-to-many relationship. I have a strongly typed dataset I need to create add and update stored procedure.
Now I can use foreach to add FruitID and FruitCrateID to database but there will be several calls for example,
...
i am trying to insert value in table page no wise.
ex-- if i click save front of 1 then it insert only 1 for main issue- dak.
if i click save front of 2 then it insert only 2 for main issue- dak. like wise..
but always it inserting page no 1 for all edition in table plz suggest me ...
i deb...
table-partitioning - 38 questions
partitioning - 247 questions.
Most questions tagged table-partitioning are also tagged partitioning.
The current wiki excerpt for partitioning is:
"Splitting a database table into multiple segments for performance or manageability."
Proposing we create a ...
I have a select statement that when run on the live production server, returns mm-dd-yyyy regardless of what I do. this only happens though when selecting the date from an another aliased select. Simplified (as my sql is quite long):-
select name,age,dob from tblone as tbltemp1
in this select...
Transparent Data Encryption, by its very nature, doesn't change any of the internal processing of queries. TDE is designed to negate the need for application developers to make any changes to their applications.
http://msdn.microsoft.com/en-us/library/bb934049.aspx contains a salient piece of ...
I am trying to code in C# with DOT42. How do I navigate to an html inside my Assets folder. I have achieved the same wit Eclipse in java with the following Code:
Uncaught Error: SECURITY_ERR: DOM Exception 18
What is the setting for out putting the query result to pane, instead of text file. I set output to text file a long time ago. But I forgot how to turn it back. Please advise.
Thanksa
I'm not sure any further comment is needed.
We have on our DB some international people that got some characters saved incorrectly on our DB (MS SQL 2008 R2).
For example we have strings like 'WilcoxonÃ'.
We got this data into the db because we take international submissions but management didn't want to use any character set eve...
I have not seen any clear, concise examples of this anywhere online.
With an existing table, how do I add a self-referencing foreign key? For example:
CREATE TABLE dbo.Projects(
ProjectsID INT IDENTITY(1,1) PRIMARY KEY,
Name varchar(50)
);
How would I write a command to add a self-re...
