RE: IO is frozen for snapshot / IO is thawed
So your server uses internal disk? Does this happen every day? At the same timeframe? Are there any SQL jobs or scheduled tasks running then?
2004-11-24
2 reads
data lake
RE: Find Min/Max Values in a Set
I know cursors aren't popular, and most of the times have worse performance, but sometimes they might do the trick elegantly and in this case probably efficiantly (although I haven't checked this)... You can declare a scrollable cursor for the simple "select distinct col from table order by col desc/asc" and then use FETCH RELATIVE […]
2004-11-23
RE: ADO doesnt connect without network
I tried to disable the firewall, but it did not work the same!
2004-11-19
Run complete backup on Primary Log Shipping Server? Bad?
Sounds like dump question and it may be it.Assume that you have SQLServerA which is production server for logshipping and SQLServerB for standby server. And assume there is Logshiipping running every 1 hour after the initial complete backup is done.So, question would be, if you run seperate daily job to run complete backup on production […]
2004-11-17
RE: SQL UDF to return hours
Hi Dave!I am a newbie when it comes to SQL, sorry for inconvienience, your answer worked perfectly, but I meant to say minutesWith your above answer, can you change that to return MINUTES instead of hours and exclude holidays that are in TableA . Lets say TableA hasHolidayDate 2004-08-09 00:00:00.000 2004-09-24 00:00:00.000 2004-12-16 00:00:00.000 2004-12-26 00:00:00.000 […]
2004-11-15
1 reads
RE: Rollbacking changes by giving date as input
I am NOT an expert.But you can try this.1. Do a transaction backup.2. Then do a restore of your database to the date that you want to roll back.3. Backup or copy out your database.4. Restore your database back to today.5. Delete all records.6. Copy back from your backup (from step 3)This will not work […]
2004-11-08
Invalid character value for cast specification
I have an "Execute SQL Task" with input parameter - GlobalVariable gv_RF_ID output parameter - Globalvariable gv_TEXT_INFO gv_RF_ID is INT (default 10322) gv_TEXT_INFO is StringHere is SQL statement: SELECT TEXT_INFO FROM RF_INDEX WHERE RF_ID = ?When I execute this Step I get an error "Invalid character value for cast specification"I ran this statement in QA, […]
2004-10-21
1 reads
User hierarchies v. Attribute hierarchies
Hi, Can anyone please tell me the difference between these two hierarchies, and why you would use one over another? Thanks
2004-10-19
1 reads
RE: need help with T-SQL Syntax
See http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=5772
2004-10-14
2004-10-14
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers