Viewing 15 posts - 5,266 through 5,280 (of 19,560 total)
Exact number of records?
Is the spreadsheet in compatibility mode by chance?
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
January 9, 2013 at 11:33 pm
Please provide ddl and the error message you are getting.
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
January 9, 2013 at 11:31 pm
I completely disagree.
Only for the sake of creating discord, malcontent, and to be argumentative because there is nothing in the question to whine about otherwise.
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
January 9, 2013 at 11:30 pm
What version of SQL Server? What is the file extension of excel you are using (xls limits to ~65000 records where xlsx limits to ~1,000,000).
If you have more than...
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
January 9, 2013 at 11:20 pm
Jeff Moden (1/9/2013)
fearghalreilly (1/9/2013)
you are working as part of the database team for the zoro online company . a junior database...
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
January 9, 2013 at 11:15 pm
That is the way it was designed in SQL Server.
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
January 9, 2013 at 10:35 pm
jitendra.padhiyar (1/9/2013)
GilaMonster (12/24/2012)
If it's using too much, lower max server memory
Is it dynamic change ? I mean if I will lower down the max memory, Will SQL server will release...
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
January 9, 2013 at 10:34 pm
dwain.c (1/9/2013)
Lynn Pettis (1/9/2013)
dwain.c (1/9/2013)
Lynn Pettis (1/9/2013)
By the way, my brain isn't functioning, what does LTEHQ mean?
I was referring to this in my prior post:
long time, experienced and heavily qualified...
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
January 9, 2013 at 7:47 pm
Stefan Krzywicki (1/9/2013)
...I don't want to start fights.
Too Late!:rolleyes:
😉
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
January 9, 2013 at 6:17 pm
You can do any of the following:
Logon Trigger
Database/Server Audit
That is if the logon you are seeking is a database logon or a server logon. If the logon is within...
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
January 9, 2013 at 6:10 pm
Stefan Krzywicki (1/9/2013)
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
January 9, 2013 at 4:40 pm
opc.three (1/9/2013)
Ray K (1/9/2013)
SQLRNNR (1/9/2013)
Cliff Jones (1/9/2013)
SQLRNNR (1/9/2013)
JAZZ Master (1/9/2013)
SQLRNNR (1/9/2013)
spasmmuscle
atrophy
The Stanley Cup
Grey Cup
World Cup
Cup of soup
Liptons
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
January 9, 2013 at 4:39 pm
Evil Kraig F (1/9/2013)
SQLRNNR (1/9/2013)
Evil Kraig F (1/9/2013)
Brandie Tarvin (1/9/2013)
Wow. Brain bleach. NOW PLEASE.Oh, c'mon. I'm not THAT ugly...
*sighs*
Snake LOVER:alien:
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
January 9, 2013 at 1:47 pm
Cliff Jones (1/9/2013)
SQLRNNR (1/9/2013)
JAZZ Master (1/9/2013)
SQLRNNR (1/9/2013)
spasmmuscle
atrophy
The Stanley Cup
Grey Cup
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
January 9, 2013 at 1:41 pm
During index rebuilds, yes I would change the log backup to every 5 minutes. Once finished, then revert back to the old schedule.
If you use one of the preferred...
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
January 9, 2013 at 1:35 pm
Viewing 15 posts - 5,266 through 5,280 (of 19,560 total)