Using MS SQL Server
in [Microsoft SQL Server]
|
US-MD-Silver Spring: SQL VMWare TV Network DBA <http://www.filcro.com/SQL-Database.html> � Installing, configuring, troubleshooting and maintaining MS SQL environments � Experience working with VMWare (ESX 4.0 preferred) � Strong SQL / scripting skills � This position is approximately 75% Database Administration and 25% Systems � Strong Active Directory an... 30 Apr 2010 21:51
Keeping rows with the minimum difference between a column and a given parameter Hello Mr. Ratchev, Here is a query that works in SQL CE: [...] Thank you for that, it really works. I even understand your query, don't know why I wasn't able to find it by my self. However my real query will be a bit more complex because there is not only one metric to compare, but several metrics. T... 1 May 2010 17:36
Keeping rows with the minimum difference between a column anda given parameter The query is not very difficult to write. The problem is using the Compact Edition which has very limited T-SQL capabilities. For example, using ROW_NUMBER can help to write a query, but that is not available in CE. Here is a query that works in SQL CE: SELECT A.RouterId, A.DeviceId, A.Metric FROM Foo AS A JO... 1 May 2010 23:04
Keeping rows with the minimum difference between a column and a givenparameter Hello, I had no luck with building an sql query to eliminate all rows except that with MIN(column - @parameter) Example Table: RouterId DeviceId Metric Other ------------------------------------------------------ 1 1 100 blabla1 1 ... 30 Apr 2010 11:41
Keeping rows with the minimum difference between a column and a givenparameter Hello, I had no luck with building an sql query to eliminate all rows except that with MIN(column - @parameter) Example Table: RouterId DeviceId Metric Other ------------------------------------------------------ 1 1 100 blabla1 1 2 90 blabla2 1 1 50 blabla3 2 1 100 ... 2 1 90 ... 2 1... 30 Apr 2010 10:34
Yellowfin 5.0 Webinar Yellowfin Business Intelligence is offering customers,industry professionals, developers, OEMS and Vendors a chance to get a walk through of the new version 5.0 features, in time for the official launch. Join Glen Rabie, CEO of Yellowfin, as he presents this webinar and launches the milestone release, Yellowfin ... 29 Apr 2010 08:57
merge two records. I'm trying to merge to records. All of the fields are the same except for dbo.MaterialProducedActualEpa.EpaName. I'm able to use a 2nd field to determine which one I want. Is it possible to show both of them in 1 record? The following try may help to understand what I'm trying to achieve. SELECT (CASE WHE... 27 Apr 2010 17:54
Whitepaper - In-Memory Analytics Yellowfin has released its latest Business Intelligence Whitepaper, this time on "In-memory Analytics" * No signup or email handover required, just click the link or cut/ past into your browser. http://yellowfin.com.au/Document.i4?DocumentId=104879 Feel free to give us any feedback Extract As the name ... 26 Apr 2010 08:01
ANN: New version of Database Workbench, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: " Database Workbench 4.0 Pro" With this version we're reached a milestone: Database Workbench is now fully Unicode enabled and offers new tools to increase your productivity. There h... 23 Apr 2010 20:39
SQL-DMO Process Issue On Apr 22, 5:38 am, Erland Sommarskog <esq...(a)sommarskog.se> wrote: Prasad (calmsqur...(a)gmail.com) writes: Inorder to monitor availability of sql server and sqlagent processes, i have used the below script. Its functioning fine as we needed. But end of the day i notice a lot of SQL-DMO process hanging... 23 Apr 2010 20:39 |