Viewing 15 posts - 8,011 through 8,025 (of 19,560 total)
Kiara (11/4/2011)
Brandie Tarvin (11/4/2011)
Ki,You do remember that Table Variables use TempDB, right?
Yup. But when I've been testing, they seem to do less r/w activity than temp tables do. Could just...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2011 at 8:38 am
Lynn Pettis (11/3/2011)
Now that we have moved data from B to A, there is more that needs to be done that we didn't tell you.
Come on people,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2011 at 4:55 am
Try connecting with the DAC port like this
sqlcmd –S127.0.0.1,1434
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 3, 2011 at 9:59 pm
How does your setup compare to the following example?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 3, 2011 at 9:56 pm
What is the OS?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 3, 2011 at 9:23 pm
Have you confirmed that you are using the correct mail server address?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 3, 2011 at 9:18 pm
Nan82 provided the easiest way to do this. Verify that your table is defined exactly the same between the old source and the new source and you should be...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 3, 2011 at 9:17 pm
Sounds like your mail server is configured to require secure authentication.
Can you script out your database mail profile and verify your settings with the Exchange admin?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 3, 2011 at 9:14 pm
Retry the above but try this
NET START MSSQLSERVER /c /f /T3608
Use t3608 instead of 3508
Then try the DAC connection (you may need to look up your dac port)
sqlcmd -S tcp:127.0.0.1,<DAC...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 3, 2011 at 9:12 pm
Lynn Pettis (11/3/2011)
Well, my daughter Kirisa was just inducted into the National Honor Society ths evening!
Congrats
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 3, 2011 at 9:03 pm
L' Eomot Inversé (11/3/2011)
SQLRNNR (11/3/2011)
Daniel Bowlin (11/3/2011)
Smörgåsbord
Boardwalk
Walkout
Sit-in
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 3, 2011 at 7:38 pm
Is that new path for tempdb valid?
Next option might be to try the DAC - dedicated administrator connection
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 3, 2011 at 7:38 pm
Try this:
(a) From command prompt type sqlservr -c -f
(b) then try
C:\>SQLCMD -q"Alter database tempdb modify file (name = tempdev, filename = 'Y:\SQL\tempdb.mdf')"
GO
C:\>SQLCMD -q"Alter database tempdb modify file (name = templog,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 3, 2011 at 7:10 pm
Because it (what the developer did) resyncs the metadata. That is what has happened here.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 3, 2011 at 6:11 pm
Try starting in minimal config (SQL Server), and then altering the paths to the correct paths.
sqlservr.exe -f
Here's a similar thread
http://www.sqlservercentral.com/Forums/Topic545301-146-1.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 3, 2011 at 6:09 pm
Viewing 15 posts - 8,011 through 8,025 (of 19,560 total)