My firewall is down and when I tried to start the Postgres service it gave me an error that said: the service started and then stopped. Some services stop automatically if they are not in use by other services or programs.
I need to start postgres for pgadmin and when I tried to connect to pgad...
@Phil I certainly would've been yawning 4 hours ago
@dezso can we get some cleanup on this, so we can send it over to Stack Overflow? I'm thinking "How do I perform this insert conditionally, here's what I'm doing now" would be a good start. I saw you were already trying to chat the user up, so let's see if we can continue that.
Am having trouble reducing response time on a query we were hoping to provide for a customer-facing web application. The table structure is as so:
delimiter $$
CREATE TABLE `test_table` (
`CustomerId` int(11) DEFAULT NULL,
`EventType` int(11) DEFAULT NULL,
`DateAndTime` datetime DEFA...
We recently switched to the FULL recovery model, with full backups being done every weekend, and differentials being taken every day.
This worked last weekend, however this weekend the differential backup failed saying that
Message
Executed as user: username. ... 9.00.3042.00 for 32-bit...
I can recommend that she backup to a NULL device, which resets things, but that's REALLY bad practice 'cause it will destroy the backup chain. I want to provide the NULL device answer with that caveat, but I feel like I could create a bigger mess by even suggesting that.
@MikeFal there's so much more that's going on here. i do wonder why she doesn't just run another full and then debug her job. it reported success when there was no success
@swasheck I did follow the KB and MSDN links she provided, it's an actual bug. Not sure which SP release of 2005 she's on, but she needs to get current on to at least 2005 SP4 (I believe)
I'm redacting the stuff about NULL device backup. Last thing I want to do is provide an answer that destroys a backup chain.
I'm simply saying "as long as you have your log backups, your diff errors are just an annoyance, just get a full done ASAP"
@MikeFal but then you also have to remember that many KBs are fixed with cumulative updates, not with service packs. And if a fix is in an RTM CU before SP1 comes out, for example, it might not be documented in the SP1 release notes.
The big problem is that many fixes are not documented - by accident, intentionally (e.g. security-related fixes aren't always documented depending on context), or because they were documented in an earlier build.
MVPs get periodic breakdowns of bugs fixed per build and the number is always higher than the number we see shown publicly on the KB.
EF drive me crazy. It can't handle synonyms either?
I have the situation where I will have multiple companies accessing a single instance of my application, but I need to segregate their data to avoid accidentally loading data for another company, and to ease per-company database backups.
Ideally, I'd like to split the data up into different data...
There's already a thing called "Te'oing" (similar to "Tebowing"). A picture of you hugging, kissing or putting your arm around the air (a fictional person beside you).
I have an SSD that, using IOmeter test, shows performance over 200MB/s. However when I run any SQL query from local machine the windows resource monitor never shows disk IO above 7MB/sec. This holds true even for queries that take over 2 minutes to run. What could the bottleneck be that it is ...
From what I can tell, this is not the last EF/CF limitation you'll come across if your project does not fit into the strict parameters of that model. Is EF/CF something you have to use, or are you using it because it's "all the rage"? I suspect if you want to do anything moderately complex you'll quickly get frustrated with all of its boundaries and seek other alternatives. — Aaron Bertrand39 secs ago
@MarkStorey-Smith Can I have a show of hands of people who have actually developed a significant body of T-SQL code using Xpath queries on XML documents?
@ConcernedOfTunbridgeWells Close to none. I was trying to do something last year that was causing me to bring the desk and my head into close contact frequently, which @MartinCairns kindly helped me out with in the end.
@ConcernedOfTunbridgeWells using xml path is a hack, and doesn't require authoritative knowledge of xml path. But until there is a built-in, they're all hacks.
@MarkStorey-Smith regex was the original subject of the 'Now you have two problems' quote.
Although it's also quite applicable to XML ;-}
@AaronBertrand All I'm doing is picking apart qualified object names, so I don't to need to process large strings at speed. The CTE one from @CadeRoux will be fine for that as it's short and sweet. Having said that, the Xpath one you linked to is no longer.
@AaronBertrand That will do nicely. It might explain why I had the vague notion there ought to be a builtin for this but couldn't find any evidence of it on a google search.
@ConcernedOfTunbridgeWells it is a very narrow use case as a built-in, but "parsing object names" is a very narrow subset of the broader "splitting strings"
@MarkStorey-Smith Might have been relevant on a 40 column mode on a BBC ca. 1985 where it actually packed the spaces into the code. Not relevant on a modern C${foo} system.
@MarkStorey-Smith I agree but sometimes I reduce it to keep a code sample in an answer from forcing horizontal scrollbars. That is more of a PITA to me.
I was just having a discussion with one of my colleague on the SQL Server performance on specifying the query command in the stored procedure.
So I want to know which one is preferred over another and whats the concrete reason behind that.
Suppose, We do have one table called
Employees(EmpNam...
A little mean maybe, but holy crap, what is this kid's end game?
@Manish let's see, I've been working with SQL Server since version 6.5. I think I am pretty sure. There are tons of tools for benchmarking SQL Server performance. Did you google benchmark SQL Server performance? — Aaron Bertrand3 mins ago
i am using c#.net with sql server 2008.now iam craeting a project.in that i want to read a number of dates from a database.these dates are stored in a single column as one by one.and the retreived data should be added to a list.
my code is given below
public List<DateTime> getholidays()
...
Just looking at:
(Source: http://xkcd.com/327/)
What does this SQL do:
Robert'); DROP
TABLE STUDENTS; --
I know both ' and -- are for comments, but doesn't the word DROP get commented as well since it is part of the same line?
I am having issues converting a string in dd/mm/yy h:i:s to yyyy-mm-dd hh:mi:ss format using SQL Sever.
I have tried using CONVERT() as follows:
select CONVERT(VARCHAR, '11/10/11 10:56:58', 120)
But that returns no change:
11/10/11 10:56:58
I have an access code using IIF statements that have 2 in 1 and I am trying to rewrite them for SQL as CASE statements but I am hitting some speedbumps.
Sum(IIf([RRDD] Not Like "12*"
And [RRDD] Not Like "13*"
And [RRDD] Not Like "16*"
And [RRDD] Not Like "17*"
And [RRDD] Not ...
I cannot get this TRIM code to work
SELECT dbo.COL_V_Cost_GEMS_Detail.TNG_SYS_NR AS [EHP Code],
dbo.COL_TBL_VCOURSE.TNG_NA AS [Course Title],
LTRIM(RTRIM(FCT_TYP_CD)& ') AND (' & LTRIM(RTRIM(DEP_TYP_ID) & ')' AS [Course Owner]
hey guys - I assume UTF-8 storage is still not supported by SQL Server 2012? I have a unix guy asking me about it. Would anyone care to update the following question with 2012 data?
I'm wondering why sql server import is detecting an excel column of mine as a double
When it clearly does not have a floating point of any kind
For a visual, here is what I'm looking at http://i.imgur.com/Ba3SIaL.png I'm unclear as to why my Quantity column is listed as "Double" I guess I could just proceed with the warnings since I know I don't need that much precision
@Zach Typically SQL Server is going to err on the side of including larger values even if none are immediately present. I'm not sure if it analyzes the entire data set or just a largely representative sample. Did you change the mapping to smallmoney for the highlighted row?
@Zach ding! That sounds like your answer. Again, it probably chooses the largest compatible type. I bet if the first 8 rows contain only 0 and 1 it doesn't choose BIT
@Zach I was just asking if you changed that mapping, but I'm also curious if you have any compelling reason to use that type.
So SQL Server sees that the column contains numbers, and makes it the most accommodating type, assuming that the largest value might not be in the first 8 rows.
Would you expect it to choose single or smaller based on the first 8 values? I think that will break for a lot of people whose 9th row is 2 billion, or 32.6
Double isn't even a data type in SQL Server. I wouldn't spend too much time worrying about it, especially if you're going to override the mapping anyway.
That's so you don't have to wait an hour for the mapping to happen. Think of a huge Excel spreadsheet stored on a network share over a really slow VPN.
Giving end users free production SQL access to write stuff in Access or Excel is wrong. Always. Tablescans, "accidental" (read: clueless) drops and deletions. Endless nightmares
Yes, on the design question. I know that posting here is a little less work than posting a question, but in general - and I don't want to speak for every single person - we're not in here to answer questions, we're here to chat. :-)
And can we petition to have stack use a different service than img.ur? At least it will buy the less fortunate among us some time to see images until their archaic IT departments catch on
Is it possible to automate the managing of indexes on my database. I'm looking to see if there are any scripts or programs that can automate this process. Would it be possible to use stats generated by SQL to determine what indexes could help performance. Then use another script based on stats...
@ShawnMelton I'd probably have to test stuff, but I'm not sure there's an appreciable difference. I believe the SQLBulkCopy class uses the same underlying process as the BULK INSERT syntax.
@MikeFal That is biggest thing I was wondering. I know SSIS has the fast-load option with BULK loads but could not find anything that compares it to the SQLBulkCopy class. MSDN states the SQLBulkCopy is less efficient if the source and destination is on the same instance.
@MikeFal I think putting in SSIS right off would just get better control and management of it. The C# program would have to be recompiled for changes, which is not that efficient in this customers case I don't think.
@MikeFal The only problem they are experiencing with the process right now is two particular classes that move data are timing out on the SQLClient side. It is trying to move about 10.5 million and is timing out after it gets about 9.6 million done for some reason.
@ShawnMelton an organic compound with the formula HN(CH2CH2NH2)2. This colourless hygroscopic liquid is soluble in water and polar organic solvents, but not simple hydrocarbons.
@MikeFal I see consultant answers being posted on that question. "If you automagically pay me $$$ I will take care of all your shortfalls, not having a DBA."
SELECT OBJECT_NAME(S.[OBJECT_ID]) AS [OBJECT NAME],
I.[NAME] AS [INDEX NAME],
USER_SEEKS,
USER_SCANS,
USER_LOOKUPS,
USER_UPDATES
FROM SYS.DM_DB_INDEX_USAGE_STATS AS S
INNER JOIN SYS.INDEXES AS I
ON I.[OBJECT_ID] = S.[OBJECT_ID]
AND I.INDEX_ID = S.INDEX_ID
WHERE OBJECTPROPERTY(S.[OBJECT_ID],'IsUserTable') = 1
data.stackexchange.com/stackoverflow/query/84763/… Apparently Skeet would have over 1.7M if the votes weren't rep-capped. I expect he might even be closer to 2M if you factor in "I didn't upvote because it's Skeet"
To find the first and last days of the month:
DECLARE @MonthStart DATETIME
DECLARE @Date DATETIME
DECLARE @MonthEnd DATETIME
-- create the required date. because today is the 21st i subtracted month.
-- since you're running the job on the first day of the new month,
-- you may want to change...
My firewall is down and when I tried to start the Postgres service it gave me an error that said: the service started and then stopped. Some services stop automatically if they are not in use by other services or programs.
I need to start postgres for pgadmin and when I tried to connect to pgad...
I need to check a condition before inserting a row into the table. Is it possible in codeigniter?
Why does this request generate an "" error ?
The request is :
SELECT * FROM table WHERE colname1 = 'N' AND colname2 like "%azer%";
Am having trouble reducing response time on a query we were hoping to provide for a customer-facing web application. The table structure is as so:
delimiter $$
CREATE TABLE `test_table` (
`CustomerId` int(11) DEFAULT NULL,
`EventType` int(11) DEFAULT NULL,
`DateAndTime` datetime DEFA...
We recently switched to the FULL recovery model, with full backups being done every weekend, and differentials being taken every day.
This worked last weekend, however this weekend the differential backup failed saying that
Message
Executed as user: username. ... 9.00.3042.00 for 32-bit...
I have an SSD that, using IOmeter test, shows performance over 200MB/s. However when I run any SQL query from local machine the windows resource monitor never shows disk IO above 7MB/sec. This holds true even for queries that take over 2 minutes to run. What could the bottleneck be that it is ...
I was just having a discussion with one of my colleague on the SQL Server performance on specifying the query command in the stored procedure.
So I want to know which one is preferred over another and whats the concrete reason behind that.
Suppose, We do have one table called
Employees(EmpNam...
i am using c#.net with sql server 2008.now iam craeting a project.in that i want to read a number of dates from a database.these dates are stored in a single column as one by one.and the retreived data should be added to a list.
my code is given below
public List<DateTime> getholidays()
...
Just looking at:
(Source: http://xkcd.com/327/)
What does this SQL do:
Robert'); DROP
TABLE STUDENTS; --
I know both ' and -- are for comments, but doesn't the word DROP get commented as well since it is part of the same line?
I am having issues converting a string in dd/mm/yy h:i:s to yyyy-mm-dd hh:mi:ss format using SQL Sever.
I have tried using CONVERT() as follows:
select CONVERT(VARCHAR, '11/10/11 10:56:58', 120)
But that returns no change:
11/10/11 10:56:58
I have an access code using IIF statements that have 2 in 1 and I am trying to rewrite them for SQL as CASE statements but I am hitting some speedbumps.
Sum(IIf([RRDD] Not Like "12*"
And [RRDD] Not Like "13*"
And [RRDD] Not Like "16*"
And [RRDD] Not Like "17*"
And [RRDD] Not ...
Is it possible to automate the managing of indexes on my database. I'm looking to see if there are any scripts or programs that can automate this process. Would it be possible to use stats generated by SQL to determine what indexes could help performance. Then use another script based on stats...
To find the first and last days of the month:
DECLARE @MonthStart DATETIME
DECLARE @Date DATETIME
DECLARE @MonthEnd DATETIME
-- create the required date. because today is the 21st i subtracted month.
-- since you're running the job on the first day of the new month,
-- you may want to change...
