Viewing 15 posts - 3,826 through 3,840 (of 9,722 total)
Revenant (11/28/2012)
Brandie Tarvin (11/28/2012)
GilaMonster (11/28/2012)
Anyone with more patience than me want to try and handle this?http://www.sqlservercentral.com/Forums/Topic1389777-1550-1.aspx
Previous threads on the subject:
http://www.sqlservercentral.com/Forums/Topic1382850-1550-1.aspx
http://www.sqlservercentral.com/Forums/Topic1368391-1550-1.aspx
http://www.sqlservercentral.com/Forums/Topic1364097-1550-1.aspx
I'm going to do a horrible thing and ask a technical...
November 28, 2012 at 12:38 pm
GilaMonster (11/28/2012)
Anyone with more patience than me want to try and handle this?http://www.sqlservercentral.com/Forums/Topic1389777-1550-1.aspx
Previous threads on the subject:
http://www.sqlservercentral.com/Forums/Topic1382850-1550-1.aspx
http://www.sqlservercentral.com/Forums/Topic1368391-1550-1.aspx
http://www.sqlservercentral.com/Forums/Topic1364097-1550-1.aspx
I'm going to do a horrible thing and ask a technical question prompted by...
November 28, 2012 at 11:36 am
SQLSACT (11/28/2012)
Now, when that change gets reflected on disk, does the changed page in Memory replace the corresponding page on disk?
"replace" is a poor choice of words here. When...
November 28, 2012 at 11:22 am
pdanes, have you checked your connection pooling properties both in the app and on the server to make sure you can reuse existing connections and that the pool isn't throttled...
November 28, 2012 at 10:52 am
Bhuvnesh (11/28/2012)
WHat if we use SSIS to do this stuff more robust more tracable .. more comfortable to handle heavy volume data. i will welcome suggest on this suggest 🙂
If...
November 28, 2012 at 10:50 am
pdanes (11/28/2012)
Other options are to do a tracert and a ping from the location of this particular Access db to see if that machine can even hit the SQL server.
EDIT:...
November 28, 2012 at 10:47 am
Ditto to what Anthony said. Additionally, SQL authentication is usually managed locally or more freely than Windows authentication. This fact sometimes makes it easy for a guy to get sysadmin...
November 28, 2012 at 10:39 am
jcrawf02 (11/28/2012)
Grant Fritchey (11/27/2012)
jcrawf02 (11/27/2012)
Okay, so looking at the new ads from redgate on the site, and thinking Steve is obviously Hannibal, which makes Grant...Mr. T?
No, no, no. I am...
November 28, 2012 at 6:16 am
We need your table DDL (CREATE TABLE statements) and some sample data to test with, please.
November 28, 2012 at 6:03 am
ssarria (11/28/2012)
Hey Pavan,some how is not working, it is giving me an error messages. It is a syntax error... sorry I am still learning SQL..
Thanks!
S
Please post all your code and...
November 28, 2012 at 5:50 am
Actually, I have a few thoughts that could get around this. Mainly via the use of a subquery that selects each distinct property and then JOINs to the other tables...
November 28, 2012 at 5:48 am
Just because SCCM requires windows authentication doesn't mean that you have to alter your SQL Server authentication settings. You just need to make sure security in the database is set...
November 28, 2012 at 5:45 am
Do you have Auto_Close enabled on your SQL Server properties?
That's the first thing I would check. If not, then I would get a network sniffer running while you try to...
November 28, 2012 at 5:41 am
Unless I'm misreading this, the buffer pool doesn't come from SQL Server's allocated memory.
BOL says
November 28, 2012 at 5:37 am
You can search stored procedure definitions by joining sys.objects to sql_modules and doing a WHERE clause with a LIKE statement on the definition column of sql_modules. That should locate all...
November 28, 2012 at 5:30 am
Viewing 15 posts - 3,826 through 3,840 (of 9,722 total)